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


"Landa" wrote:

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!