Saturday, 8 August 2020

Find First Empty Column in a Row | Excel

If you want to find first EMPTY column in row, then use this formula into (column I) to find the index of the empty column (see column I). 

#N/A means there is no column , like row 3


 =MATCH(TRUE,INDEX(A3:G3="",0),0)

No comments:

Post a Comment