Check for duplicates?

[Vass]

I have a long list of barcode numbers I have created and checksum'd
I'd like to check I dont have any duplicates before I label my stock.
Anyone got a bit of excel wizardry that will look at a column of numbers and
hightlight any duplicates?
TIA

 

[Pete_UK]

Do you mean highlight as in colour the cell (using conditional
formatting), or do you want to have an indicator in another column, so
that you can apply a filter to see just the duplicates?

Pete

 

[Vass]

Do you mean highlight as in colour the cell (using conditional
formatting), or do you want to have an indicator in another column, so
that you can apply a filter to see just the duplicates?

Pete

really don't mind
either way will be fine thanks

 

[Pete_UK]

Okay, assuming your numbers are in column A, starting with A1, put
this formula in B1:

=IF(COUNTIF(A$1:A1,A1)=1,"First","Duplicate")

This will put the word First in column B against the first occurence
of a number, and Duplicate against any repeats of that number -
obviously, you can change these words to suit. Copy the formula down
for as many rows as you have data.

You can then apply autofilter to column B to select "Duplicates" for
further investigation (which you can't do with conditional
formatting).

Hope this helps.

Pete

 

[Vass]

Okay, assuming your numbers are in column A, starting with A1, put
this formula in B1:

=IF(COUNTIF(A$1:A1,A1)=1,"First","Duplicate")

This will put the word First in column B against the first occurence
of a number, and Duplicate against any repeats of that number -
obviously, you can change these words to suit. Copy the formula down
for as many rows as you have data.

You can then apply autofilter to column B to select "Duplicates" for
further investigation (which you can't do with conditional
formatting).

Hope this helps.

worked a treat Pete
thanks

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

worked a treat Pete
thanks