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

"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!!