HOW DO I IDENTIFY DUPLICATES IN A COLUMN OF NUMBERS
 

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?

HOW DO I IDENTIFY DUPLICATES IN A COLUMN OF NUMBERS
 

Hi
see:
http://www.cpearson.com/excel/duplic...tingDuplicates
http://www.cpearson.com/excel/duplic...gingDuplicates

--
Regards
Frank Kabel
Frankfurt, Germany


JAMESMCC wrote:
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?

HOW DO I IDENTIFY DUPLICATES IN A COLUMN OF NUMBERS
 

OR MAY BE SOMETHING LIKE THE UNAUTHORIZED VERSION

HI
SEE:
HTTP://WWW.CPEARSON.COM/EXCEL/DUPLIC...TINGDUPLICATES
HTTP://WWW.CPEARSON.COM/EXCEL/DUPLIC...GINGDUPLICATES

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

--
REGARDS
FRANK KABEL
FRANKFURT, GERMANY

HOW DO I IDENTIFY DUPLICATES IN A COLUMN OF NUMBERS
 

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



"JAMESMCC" wrote:

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?