I ran into a problem with the duplicates. There are numerous colums in the
spreadsheet of which 3 columns have different information. Therefore, it is
recognizing it as an unique record. But I would like to delete it anyway. I
need the 3 columns to remain for the rest of the records. Can anything be
done?

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