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

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

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

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!
==============================================


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

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

Range("A1").End(xlDown).Row+1

HTH
--
AP

"Bruce Henson" <Bruce a écrit dans le
message de ...
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).

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