"IF" with no "false" action - Using Text

B

bleu808

All,

I am sorry to start this as a new thread - but I think some may see the
original as closed, and not look at any new posts. Just looking for
some help :confused:
------------------------
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 - 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(a5=" ",a4,NOP)

Thanks all!

Bleu
 
R

Rowan Drummond

Save your work and then try:

Select column A. Hit F5. Click on Special. Click on Blanks, then OK.
Type = and then hit Up Arrow. Hold Control Key and hit Enter.

Hope this helps
Rowan
 
D

Danny@Kendal

bleu808 said:
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.
Click to expand...

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
 
Top