Tuesday, October 4, 2011

yogi_Extract Entries That Are Unique For A Specified Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
a user asked:
How do I find/delete duplicate contact entries in a spreadsheet?
I have 1450 contact entries in a spreadsheet. They each have fax, telephone, name, and company.
I need to identify and delete any entries with a duplicate fax number. Also, I need to retain the integrity of the spreadsheet upon identifying and deleting, such that corresponding records stay with each other.
Fax Tel Name Company
919-807-3450 919-807-1234 Jonathan Peters Swift, Inc.
919-807-3450 919-807-3456 Jenny Carr Swift, Inc.
919-663-0876 919-779-9734 Alex Grafton Thorsys, Inc
Ex - Jonathan and jenny would be identified as being duplicates and I would delete 1 of them. *the entry selected to be deleted would deleted completely, such that Alex would then be the 2nd entry, with all of his records.
Any help is a great help!