Ways to identify types items with duplicate them, plz help!

[chermaine]

Hope someone could help me!!
I have two files, where i got need to cross checked against some of the
items within them. Now I have a list of item code where they may be
replicated and so it comes up up with over 1000 numerical codes!!
actually it got maybe a few hundred types in there. I want to set
myself a "database" which reserve all those types of code without any
duplicate them, is there any method or formula can help me doing this?
coz i wanna run a vlookup afterwards but with such a big list of items
i am sure it will slow down my computer to process.

Urgent, please take a look n giv a hand on it. 1000 thanks!!

 

[Guest]

Here's one way to produce a list of unique items from all existing records ..

In a new sheet, copy & paste special as values the 2 source lists into col A
from row1 down sequentially, one list below the other. Then ..

Place in B1:
=IF(A1="","",IF(COUNTIF($A$1:A1,A1)>1,"",ROW()))

Place in C1:
=IF(ROW()>COUNT(B:B),"",INDEX(A:A,MATCH(SMALL(B:B,ROW()),B:B,0)))

Select B1:C1, copy down to the last row of data in col A

Col C will return the list of uniques within col A, with all results neatly
bunched at the top. Then just copy col C and paste special as values
elsewhere (then sort, etc to taste).

 

[Guest]

u can do it in two ways.

1 either create a pivot and get the unique fields.
2 or use advanced filter and drill down for unique records.

hope it will serve ur purpose