data

K

Karel

data won't repeat names in column. example
A1=my name B1-B13 various data for me
A14=your name B14-B23 various data for you

how do I get my name in A2-A13 and yours in A14-A23?

it's never the same names or rows of data.

Thank you very much!
 
G

Gord Dibben

Select column A and F5>Special>Blanks>OK

Type = sign in active cell then point or arrow to cell above.

Hit CTRL + ENTER to insert formulas with the missing names.

You can then copy column A and Edit>Paste Special>Values>OK>Esc to get rid of
the formulas.


Gord Dibben MS Excel MVP
 
Top