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