Data duplication

[glenrayel]

I have a huge Excel spreadsheet that documents automobile vehicl
identification numbers (VIN). I need some type of warning device o
indicator on the spreadsheet to inform me when the VIN has bee
duplicated somewhere else in that spreadsheet. I don't care if i
warns me by highlighting or chaging the color of the duplicate cell o
sounds a loud fog horn, just as long as I am warned that the number ha
been duplicated. Is there anyone out there that could tell me how t
do that? Better yet - show me an example in text since I am not a
expert by any means in Excel and do not always understand the language
I have the 2003 version of Excel if that makes any difference.

Thank you in advance,
glenraye

 

[RagDyeR]

Chip Pearson has a web site that can help you on this.

Go to:

http://www.cpearson.com/excel/topic.htm

And scroll down to see a number of topics on "Duplicates".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
".
I have a huge Excel spreadsheet that documents automobile vehicle
identification numbers (VIN). I need some type of warning device or
indicator on the spreadsheet to inform me when the VIN has been
duplicated somewhere else in that spreadsheet. I don't care if it
warns me by highlighting or chaging the color of the duplicate cell or
sounds a loud fog horn, just as long as I am warned that the number has
been duplicated. Is there anyone out there that could tell me how to
do that? Better yet - show me an example in text since I am not an
expert by any means in Excel and do not always understand the language.
I have the 2003 version of Excel if that makes any difference.

Thank you in advance,
glenrayel

 

[Andy B]

Hi

There are lots of duplicate functions and macros here:
http://www.cpearson.com/excel/duplicat.htm

Enjoy!
Andy

 

[Jason Morin]

There is a method that uses COUNTIF and Validation. The
easiest way to show you would be for you to visit MVP
Debra Dalgleish's site:

http://www.contextures.com/xlDataVal07.html

It's the first section called "Prevent Duplicates".

HTH
Jason
Atlanta, GA