how to remove duplicates ONLY within the same category

L

Landa

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!
 
H

Himani

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 !!
 
L

Landa

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
 
G

Gunnar Lysaker

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

Veterinary_Medicine

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