Hi,

I would like to find / list any duplicated numberID in my spreadsheet, can you guys please help me.

For example:

Name IDnumber State
Product1 0001 NJ
Product2 0002 NY
Product1 0001 NJ

In this case, I will just delete either the first or third row in the spreadsheet. Thanks for your help.

ScottGem

Sort by ID number and scan for dups.

Depressed in MO

Or you can Save as a Text file, Import into Access, bring in your numbers, and then do a group by-then run your query. This can get rid of duplicates too, without having to spend a lot of time doing it manually in excel.

Duane in Japan

Duplicates In Data In Excel

For you if you need it or others looking at the archives, I like the highlighting so I can see what I am going to delete first, there are others that will just delete.

By the way, this was the first choice on google, excel vba duplicate row, then 2 minutes of surfing the site.

Depressed in MO

"Bringing into Access (if they have it) is a good suggestion but why expeort to text first? Access will import/link to Excel files fine."

Scott Gem, you are correct. But with my system, sometimes we have to manipulate our data and Access's default settings don't always work when manipulating our data. I should not have put the part about converting anything to text as that was really only relative to my own personal experience and use.

Thanks for pointing that out.

T