"bleu808" wrote in
message ...

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 - just what I thought might work...

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 I've understood you correctly you just want to fill in the blanks beneath
each name with the name immediately preceding it.

Does this link help?
http://www.contextures.com/xlDataEntry02.html