how to remove duplicates by "person", not by entire column
How do I remove duplicates "PER PERSON" and not for the whole sheet. Example, each person has duplicate values of apple, but I only want to have one of name of each person containing apple.
Thank you!
*I know about the remove duplicates option in excel but I believe it will remove all dup's from the sheet and only leaving joe apple, which is not what I want to do.
Last edited by eeps24; 05-08-2017 at 09:41 AM.
Enter formula in C2
Formula:
Please Login or Register to view this content.
Then in D2 and copy down
Formula:Please Login or Register to view this content.
v A B C D 1 Joe apple Unique Name list 2 Joe apple Joe apple 3 Sue apple Sue apple 4 Sue apple Mike apple 5 Mike apple Mary apple 6 Mike apple 7 Mary apple 8 Mary apple 9 Mary apple 10 Mary apple
Last edited by AlKey; 05-08-2017 at 09:57 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
thank you Alkey, much appreciated!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks