Finding empty cells
Finding empty cells
(OP)
I have a range of data but within this range there are some empty cells, some cells containing text and others with numbers. How can I find the first empty cell within each column? Say my data was in range A1:B25 wth cells A3 and B15 empty I want cell A26 to display 3 and B26 to display 15.
I can do this using VB but i want to try and get away from this solution if possible. The spreadsheet will be used by others so i dont want to rely on them having to run a macro and as the sheet is 10000's line long and approx 10 column there is a noticeable delay for the macro to run so i dont want to autmomatically run the macro each time the sheet is updated.
I can do this using VB but i want to try and get away from this solution if possible. The spreadsheet will be used by others so i dont want to rely on them having to run a macro and as the sheet is 10000's line long and approx 10 column there is a noticeable delay for the macro to run so i dont want to autmomatically run the macro each time the sheet is updated.





RE: Finding empty cells
If you enter:
=MATCH("",IF(ISBLANK(A1:A25),"",A1:A25),0)
in cell [A26], and then hit Ctrl-Enter (enter as array formula), you should get your desired result. Of course, it might be better to use a named range to refer to your data.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Finding empty cells
RE: Finding empty cells
RE: Finding empty cells