Hi there...

What I´m trying to do its pretty simple, but not to me.


i m havin 2 sheets in excel. in one of those UNIQUE records are there wit
some corresponding values in another column.... bt in another sheet there is
only one column and t data is nt unique.
ex....
COLUMN 1 COLUMN 2

ACTB005 1
ACTB009 2 UNIQUE RECORDS
ACTB010 3
ACTB018 4
ACTB020 5
ACTB025 6




and

ACTB005
ACTB009
ACTB010
ACTB010
ACTB018 Repeted records
ACTB018
ACTB020
ACTB020
ACTB025
ACTB025

and the output is supposed 2 be lke tis

ACTB005 1
ACTB009 2
ACTB010 3
ACTB010 3
ACTB018 4
ACTB018 4
ACTB020 5
ACTB020 5
ACTB020 5
ACTB025 6