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