Office help .. i think Excel

[first_major]

Help Needed Excel


lets say i have a list of coutries and there code
example




1 usa
44 uk
93 afhgan
and so on till there is about 7000 entries


what i want to do is see if there is any duplicate

lets say in entry 1 there is usa with code 1 and in entry 200 there is also usa code 1 .


is there any way i can catch this without having to guess which entrie has a dupliate ..
any matching or something like that


i would appreciate the help

[AllGamer]

Sure

just sort it by number (country code) colum

:t

[Swordfish]

a tough one....:( ...but easier solution would be to create a macro.

check out the following link.:)

http://support.microsoft.com/default.aspx?scid=kb;en-us;213355

[first_major]

AllGamer
i dont think sorting will help coz there is about 21000 entries and i dont know which of them has duplicates
thats would take me ages


swordfish i think u did it with the marco stuff ( ill try and tell u what happens with me )


thankks guys

[rangeral]

Or activate clippie the office assistant in help and do a search on how to use queries if it fits the bill. He's helped me alot in building an access db, a much maligned guy, ha. :)

[DocEvi1]

I didn't know that sort of stuff was there on the MS site.

I have done stuff like this in the past and the easiest way is indeed to write a macro (although the MS way is very complicated in comparison to some of mine, although possibily more versitile)

If you need a guiding hand, just yell.

Stefan