Duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate lines in spreadsheet 1
A Lotto Numbers generator 3
remove duplicate rows from specific data in a column; excel 2007 1
find duplicates with the first three digit that are the same. 1
I've borrowed this formula for finding duplicates 5
Add one more criteria 2
Best Gmail Backup Tool to use in 2025? 3
suming every 3rd column 7

Back
Top