Duplicate Entries

  • Thread starter Thread starter Mario
  • Start date Start date
M

Mario

Hi, I've searched previous posts as I know I saw the answer but can't find
it now and forgot to print it last time.

I'm inputting a number of part numbers (600 of them) in column A and need to
identify duplicates
as I enter them (on the fly).
Conditional formatting?

What I'd like is if I input a previously entered part number, any and all
occurrences of previous entries
of that part number to highlight so I stop double entries.

Please, not a macro as I'm not into macros yet.

I'm using Excel 2010 and also need the solution to also work on my other
machine using the 2007 version.

TIA.
 
Mario explained :
Hi, I've searched previous posts as I know I saw the answer but can't find it
now and forgot to print it last time.

I'm inputting a number of part numbers (600 of them) in column A and need to
identify duplicates
as I enter them (on the fly).
Conditional formatting?

What I'd like is if I input a previously entered part number, any and all
occurrences of previous entries
of that part number to highlight so I stop double entries.

Please, not a macro as I'm not into macros yet.

I'm using Excel 2010 and also need the solution to also work on my other
machine using the 2007 version.

TIA.
Click to expand...

Step1: Select ColumnA.
Step2: Open the CF dialog and enter the following formula:
=COUNTIF($A:$A,$A1)>1
Step3: Set formatting to use shading OR bold, red font

This will flag the dupe AND its original entry.
 
GS said:
Mario explained :

Step1: Select ColumnA.
Step2: Open the CF dialog and enter the following formula:
=COUNTIF($A:$A,$A1)>1
Step3: Set formatting to use shading OR bold, red font

This will flag the dupe AND its original entry.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Click to expand...
You are amazing, thank you very much Gary, very fast reply!
 
Back
Top