Align Column Data to match row locations

[powderskier9]

Hello,

I have a problem that needs to be solved in Excel. I have two column
of data, and need to align the information in one column(B), with th
information in another(A).

For example:

Column A Col B

CODE1 CODE4
CODE2 CODE27
CODE3 CODE45
CODE4
onto CODE45

This does not work with a simple data sort since there are space
between the values in Column B that need to be aligned with the correc
row in Column A. Currently the company manually copies and then paste
the correct value in Column B to the correct position in Column B tha
is aligned with its match in Column A.

Cheers and thanks for the help,.

Mar

 

[Fabio Coatis]

Supposing your range is A1:B20
In C1 put =IF(COUNTIF($B$1:$B$20,A1),A1,"") and fill down to C20

Hope this helps
Fabio Coatis