complete blank cells

[Mery]

I have some blank cells which have to be complete once. Example, same people
have a keys, but all cells doesn't complete,

358 John
John
423 Mery
Mery
Can somebody help to solve the problem,
Thanks very much
Mery

 

[Gord Dibben]

Assuming the missing numbers are in column A.............

Select column A and F5>Special>Blanks>OK

Type an = sign in the active blank cell then point or arrow up the cell above.

Now hit CTRL + ENTER to fill down.

Copy column A and Paste Special>Value>OK>Esc


Gord Dibben MS Excel MVP

 

[Mery]

Korisnik "Gord Dibben" napisao je:

Assuming the missing numbers are in column A.............

Select column A and F5>Special>Blanks>OK

Type an = sign in the active blank cell then point or arrow up the cell above.

Thank`s Gordon

Now hit CTRL + ENTER to fill down.

Copy column A and Paste Special>Value>OK>Esc


Gord Dibben MS Excel MVP

Thank`s Gord Dibben, you helped me very much!
Mery