HOW DO I IDENTIFY DUPLICATES IN A COLUMN OF NUMBERS

J

JAMESMCC

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?
 
T

TK

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
 
Top