Duplicate Items in Excel Question

[PanchoC]

I have a list of numerical values in an excel file. Currently, there are about 400 in the list.

They are listed in order from lowest # to highest #, but I am looking for a way to flag any duplicates.

For example, let's say I have in the file a list of four digit numbers starting at 0001 up to 0400. But, I need to be able to flag any that are exact duplicates (that is, if I had two 0026 and three 0353, I need to know it).

Anyone know a way to do this?

[sdkfz]

I saw this post a few weeks back, don't remember who it was who had the answer, but I did save it...

Deleting duplicate entries in Excel 2003

Formula code: =(b2==b1)

In column C (assuming the duplicates are in column B, and I've sorted by column B).

Then I copy this all the way to the bottom (ctrl-down arrow goes to the bottom of a contiguous region, ctrl-d will copy the top cell into all selected cells under it). Now column C will contain a bunch of TRUE and FALSE values.

Any row that says "TRUE" in column C has the same value in column B as row above it. You can't sort by column C yet because excel will recalculate and change all the values. So select column C, copy it, then go to Edit -> Paste Special --> and paste Values.

This turns the formulae into the values TRUE or FALSE. Now you can sort by column C and all the rows that have TRUE there are duplicates, so you can delete them.