HOW DO I IDENTIFY DUPLICATES IN A COLUMN OF NUMBERS

[Guest]

I USE SPREADSHEETS TO PREPARE SCHEDULES, AND HAVE OCAISIONALLY DUPLICATED A
LOCATION IN A COLUMN. i WOULD LIKE TO BE ABLE TO CHECK A COLUMN TO MAKE SURE
THAT IT DOES NOT CONTAIN DUPLICATES, AND HIGHLIGHT OR OTHERWISE IDENTIFY
THEM IF IT DOES.
HELP ANYONE?

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

 

[David McRitchie]

OR MAY BE SOMETHING LIKE THE UNAUTHORIZED VERSION

HI
SEE:
HTTP://WWW.CPEARSON.COM/EXCEL/DUPLICAT.HTM#HIGHLIGHTINGDUPLICATES
HTTP://WWW.CPEARSON.COM/EXCEL/DUPLICAT.HTM#TAGGINGDUPLICATES

YOU WILL HAVE TO CONVERT AT LEAST SOME OF THE CAPITALS TO LOWER
CASE FOR THIS TO WORK

 

[Guest]

John Walkenbach author of the Bible not that Bible - Excel 2000 Bible -
has a
procedure available on His web site.

go to

J-walk.com search for "nodupes" wiithout the quotes


Good Luck

Thomas