Hi guys,
I hope someone can help or point me in the right direction. i have two spreadsheets with name surname and email address field's. I can put this data into one spreadsheet but then i need to delete all of the duplicates so i am left with completley unique data. All the help tutorials i can find will remove the duplicate but still leave the original, i want both to be removed. Is there a formula or program that will help me do this?
Thanks in advance,
Dan
Hi Dan,
Since you have already put all the records into the same sheet, why not just use the standard Data Filter and select the 'Unique' parameter?
Rgds
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
Hi Richard,
The standard unique filter will unfortunatel not remove the originals.
For example if i had
Jon jon@email.com
Ralph ralph@email.com
Stacey Stacey@email.com
Jon jon@email.com
I would like it filtered to only leave
Ralph ralph@email.com
Stacey Stacey@email.com
so it removes the duplicate and original. Is this possible at all?
Any help would be greatly appreciated!
why not create a helper column where you calculate if a value in column A occurs more than once, i.e. with your data in column A, use something like this in column B
=COUNTIF(A:A,A1)
copy down all rows
then sort by column B and delete anything that has a value greater than 1 in column B
Hi,
Indeed a unique filter won't also delete records, but I had assumed you would extract the unique records to a temporary area, delete the original records and then replace them with the previously filtered data.
However teylyn's suggestion will also work.
Regards
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks