View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default 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).