How to find out repeated data

  • Thread starter Thread starter kingkingking
  • Start date Start date
K

kingkingking

Can anybody tell how we can find out any repeated data in the worksheet
easily and then delete it.
 
Can anybody tell how we can find out any repeated data in the worksheet
easily and then delete it.
Click to expand...

how is your data setup now?
what version of excel are you using?

if its all in 1 column in excel 2003 or earlier

- highlight your data
- click data
- click filter
- click advanced filter
- click unique records only checkbox and ok
- this will filter all your duplicates
- you can copy&paste it without the duplicates
 
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

How to get tweets in chronological order? 2
Excel 2003 extract repeating cells 9
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Delete repeated values 2
Incoming connection disappear 2
Getting data out from Excel File into PowerPoint (Linked in) 1
Excel Vertical to horizontal repeat after 16 rows 3
Date formatting 4

Back
Top