If you really want to get down and dirty with duplicates, I would suggest
brettdj's Duplicate Master, found he

http://members.iinet.net.au/~brettdj/

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.




"dcost@sovereignbank" wrote
in message ...
I have a hugh file (10,000 entries) and am trying to wean out the
duplicates.
I inserted a column and ran If(B1=B2,"DUP",""). However, it's still time
consuming to delete all the duplicates. Is there a way that I could # the
duplicates (each dupl is #2)and just put in some formula to delete all the
2's.