I have a list of 6,000 rows in Column A. The first 5,530 rows contain numbers, such as 223432, 223433, etc.
Row 5,531 contains a blank, as does all subsequent rows. If I do a test on cell 5,531 and in B5531 type =A5531="" I get TRUE.
What I want to do is find the first blank cell in Column A, so I tried =MATCH("",A1:A6000,0).
However, this returns an #N/A.
Does anyone know why this happens? Is there a more reliable test?
Thanks,
MikeG
Row 5,531 contains a blank, as does all subsequent rows. If I do a test on cell 5,531 and in B5531 type =A5531="" I get TRUE.
What I want to do is find the first blank cell in Column A, so I tried =MATCH("",A1:A6000,0).
However, this returns an #N/A.
Does anyone know why this happens? Is there a more reliable test?
Thanks,
MikeG