complete blank cells

M

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
 
G

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
 
M

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

Thank`s Gordon
Now hit CTRL + ENTER to fill down.

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


Gord Dibben MS Excel MVP
Click to expand...

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