how to remove duplicates ONLY within the same category

[Guest]

Hi, grateful if you could help me on this regarding removing duplicates ONLY
within the same category but not across categories.
e.g.
item category
hair hair restoration
hair loss hair restoration
hair hair restoration
hair hair care
shampoo hair care

I want to return -
item category
hair hair restoration
hair loss hair restoration
hair hair care
shampoo hair care

Any help would be much appreciated!

Thanks!

 

[Guest]

Use Advance Filter to show only unique records.

Data menu -> Filter -> Advance Filter -> Select range data and also check
"Unique records only"

And if you want to copy filtered data to another location then specify
location.

Hope this helps !!

 

[Guest]

Hi Himani,
Thanks a lot for your suggestion!
I have tried this method before but while it can filter out the duplicate
for "hair hair restoration", it will also filter "hair hair care".
However, I want to filter duplicate within the same category only. If the
duplicate appears in another category, I want to retain it.
Is there a way to do it?
Thanks!
Landa

 

[Guest]

Hi
First, you have to put them in the same cell using A1&b1 into a column. Then
use advanced filters. The split the column using data->text to columns.
G.

 

[Guest]

If you use A1&"-"&B1 then, text to column transformation will be more useful.

 

[Guest]

This is great! Thanks Veterinary_Medicine and Gunnar Lysaker