I got a specific range, lets say A1:A4. The cells could either be empty
or include a number.
I need a formula which finds the first cell that is not empty in range
A1:A4 (and shows the value of the first not empty cell). This formula
should be located in cell B1.
Then cell B2 should find the second not-empty cell in range A1:A4 and
so on.
Thanks in advance guys. I'd rather not use macros for this one.
--
Cello
------------------------------------------------------------------------
Cello's Profile:
http://www.excelforum.com/member.php...o&userid=18981
View this thread:
http://www.excelforum.com/showthread...hreadid=393305