"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