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.

Hi Steve
One way would be to use Advanced Filter
Mark your block of data.
DataFilterAdvancedFilter 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.

--
Regards

Roger Govier


"Steved" wrote in message
...
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.

Thankyou.

"Roger Govier" wrote:

Hi Steve
One way would be to use Advanced Filter
Mark your block of data.
DataFilterAdvancedFilter 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.

--
Regards

Roger Govier


"Steved" wrote in message
...
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.