Need formula to get the address of 1st cell empty in a range
Posted by Vera on January 27, 2002 3:39 PM
In range B1:B55 I have formulas that return numbers from other cells. Sometimes the formulas will return "" (no number). I need to get in C1 the address of the first cell in B1:B55 that will have as result no number ("").
Nested If doesn't work because the 7 limitation. I tried the boolean approach but I ran into the problem that it will not work because I want the result to be an address (" boolean If " works only with numbers as I know). Thank you so much for any help.