K
KimC
I'm wanting to display the value in column A that corresponds with the first
blank cell in column B - what formula do I need to use?
blank cell in column B - what formula do I need to use?
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.
J
Joel
Use the Array formula below. Don't type the curly brakckets but type
Shift-Cntl-Enter t make the formula an Arrray formula.
{=INDEX(A1:A100,MATCH(1,--(B1:B100=""),0))}
Shift-Cntl-Enter t make the formula an Arrray formula.
{=INDEX(A1:A100,MATCH(1,--(B1:B100=""),0))}
K
KimC
Thankyou for you help, however I'm recieving an #NUM! error - what could be
making that happen?
making that happen?
K
KimC
Thanks, I got it to work!! I was doing the whole column instead of a range.
J
Joel
Do you need your other posting answered or is this part of that solution?
K
KimC
I do need the other one answered as well that one is seperate to this one.
Thanks for you help
Thanks for you help