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).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"chermaine" wrote:
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!!