Find first blank cell in range

[Sean Anderson]

Hello,

Why doesn't this formula work? I'm trying to find the row # of the first blank cell in a range.


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

It works when I search for everything else.

Can someone help?

[Carim]

Hi,

Use an array function - use Control Shift Enter instead of Enter -

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

[Sean Anderson]

Thanks for the tip. I also found this one, but I like yours better.

=MATCH("",IF(ISBLANK(A1:A100),"",A1:A100),0)

[Carim]

Glad you could fix your problem ...

Thanks for the feedback