Hi, this one is a doosie! If anyone can help it'd be really great.

I have three columns of data....A1:A10, B1:B10 and C1:C5.

Column A is Numeric Data in each cell, Column B contains text in each cell,
and I want my function to work on column C.

I want the fuction to check down along column A, from A1, until it finds a
value greater than zero, at which time it will copy that A cell's
corresponding B cell into C1. (e.g: =IF(A10,B1) ) However, if at any time a
value is entered into C1, then I want the function to copy the next value it
finds into C2 instead, and so on into C3 etc.

With this sheet, column B has about 100 text entries, but only 10 or so of
those entries corresponding numbers in column A will be greater than 0. I
want all those text entries organised at the top of column C for easy
referance, so putting a seperate function into each of 100 column C cells is
not an option.

Does anyone have any ideas?