I want to index the first blank cell in a column of data

B

Bruce Henson

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).
 
R

RagDyer

Does this work for you:

=1+MAX(MATCH({"zzzzzzz",9.9999999E+307},A:A))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
B

Biff

Hi!

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=MATCH(TRUE,A1:A100="",0)

Biff
 
Top