Find the First Blank Cell In a range

0

0013

Does anyone know of a formula to find the first blank cell in a range that has more than one blank cell in it?

MATCH("",range,0) returns #NA

Thanks
 
D

Don Guillett

this will do it but not if something in e2.
=MATCH("*",E2:E200,0)

--
Don Guillett
SalesAid Software
(e-mail address removed)
0013 said:
Does anyone know of a formula to find the first blank cell in a range that
Click to expand...
has more than one blank cell in it?
 
G

Guest

Don,
this is not working for me and I did not expect it would.
I think in this case it is best to use an additional
column with an IF
F2 =IF(E2="", 0, 1), copy,
and then use
=MATCH(0, F2:F200, 0)

Kostis
 
H

hgrove

0013 wrote...
Does anyone know of a formula to find the first blank cell in a
range that has more than one blank cell in it?
Click to expand...

Try the array formula

=MATCH(TRUE,ISBLANK(Range),0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
VLOOKUP text vs number issues returning value 13
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Sumproduct not working 5
Return BLANK is cell value sought is blank 13
Removing #N/A from an "If/Then" statement 4
Referencing the values of multiple cells in conditinal formatting. 0

Top