G
Guest
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
MATCH("",range,0) returns #NA
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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)
=MATCH("*",E2:E200,0)
--
Don Guillett
SalesAid Software
(e-mail address removed)
has more than one blank cell in it?0013 said:Does anyone know of a formula to find the first blank cell in a range that
D
Domenic
Hi,
=MATCH(TRUE,A1:A10="",0)
entered using CONTROL+SHIFT+ENTER
Hope this helps!
=MATCH(TRUE,A1:A10="",0)
entered using CONTROL+SHIFT+ENTER
Hope this helps!
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
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...
Try the array formula
=MATCH(TRUE,ISBLANK(Range),0
Does anyone know of a formula to find the first blank cell in a
range that has more than one blank cell in it?
Try the array formula
=MATCH(TRUE,ISBLANK(Range),0