Duplicates

S

Steved

Hello from Steved

I have 3 colums A, B and C

Please How do I dentify Duplicates so I can Delete them please.

I have over 4,000 rows to check.

Thankyou.
 
R

Roger Govier

Hi Steve
One way would be to use Advanced Filter
Mark your block of data.
Data>Filter>AdvancedFilter and click on Unique values only.
I would Copy to another location e.g. Sheet2 then delete the original Sheet
when you are satisfied you have the data hyou require.
 
S

Steved

Thankyou.

Roger Govier said:
Hi Steve
One way would be to use Advanced Filter
Mark your block of data.
Data>Filter>AdvancedFilter and click on Unique values only.
I would Copy to another location e.g. Sheet2 then delete the original Sheet
when you are satisfied you have the data hyou require.
Click to expand...
 
Top