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
--
Vass
'06 R1, '90 CBR1000F
www.doubleyolk.co.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

On Oct 24, 7:06 pm, "Vass" wrote:
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
--
Vass
'06 R1, '90 CBR1000Fwww.doubleyolk.co.uk

"Pete_UK" wrote in message
ups.com...
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
--
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.

Pete

On Oct 24, 7:18 pm, "Vass" wrote:
"Pete_UK" wrote in message

ups.com...

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
--
Vass

"Pete_UK" wrote in message
ups.com...
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
--
Vass

You're welcome - thanks for feeding back.

Pete

On Oct 24, 8:01 pm, "Vass" wrote:
"Pete_UK" wrote in message

ups.com...



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
--
Vass- Hide quoted text -

- Show quoted text -