You can't do that as the formula would overwrite the value, but you could do
this in an adjacent columns.

In B1 enter

=INDEX($A$1:$A$1000,MAX(IF($A$1:$A1<"",ROW($A$1:$ A1))))

as an array formula, so commit with Ctrl-Shift-Enter, and then copy down.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bleu808" wrote in
message ...

All,

Can anyone help with a variation if this earlier thread? This is
exactly what I am looking for, except I am not using a date function -
I am using text.

so, I have few cells that look like this. (actually have about 8,000
cells worth of info on the spreadsheet.)

A
1 BOB
2
3
4
5 MIKE
6

So, what I am trying to is this -

a2 is blank, it should = a1 - thats easy... but - a5 is not blank - i
want it to remain as Mike. I used this variation, since I am not
using time.

=IF(a5=" ",a4,NOP)

Thanks all!

Bleu


--
bleu808
------------------------------------------------------------------------
bleu808's Profile:
http://www.excelforum.com/member.php...fo&userid=9196
View this thread: http://www.excelforum.com/showthread...hreadid=487594