Thread
:
I want to index the first blank cell in a column of data
View Single Post
#
4
Posted to microsoft.public.excel.misc
Biff
Posts: n/a
I want to index the first blank cell in a column of data
Hi!
Entered as an array using the key combo of CTRL,SHIFT,ENTER:
=MATCH(TRUE,A1:A100="",0)
Biff
"Bruce Henson" <Bruce
wrote in message
...
I'd like to know how to index the first blank cell in a column of data, so
that I can return that number as a reference for a report (to use as an
index
value for returning other values in that row).
Reply With Quote