deleting duplicate value in columns

  • Thread starter Thread starter Jim Brokenshire
  • Start date Start date
J

Jim Brokenshire

What is the best method to delete rows containing dulicate (same number)
numbers in a column (Excel 2000)? The workbook has over 30,000 rows which
makes it impractical to sort and then delete the duplicates page by page.
Thanks in advance.
 
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

X,Y,Z values to be extracted and posted respectively in excel 2
error in highlighting duplicate values in excel 1
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Delete Cells on value 5
lookup and return column number 2
Deleting Non-Duplicate Rows 1
Duplicates 2
Deleting Duplicate Row Macro Question 1

Back
Top