Many thanks to you, this is a real time saver.

"dcost@sovereignbank" wrote:

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.