How to remove duplicate records easy way

Question

Hi,

I have single column with product names, and I would like to remove the duplicate records

Ex:

Panasonic xl10

SIXA

Traszon

SIXA

Panasonic

There are two SIXA, so we remove one (note: we only look for exact match, so Panasonic vs Panasonic xl10, they both stay)

I already tried filter function, but could not figure out how I could remove it

Thanks

roadhouse · Accepted Answer

Use the summary tool and group on product name. Bam!