| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify numbers that only occur once in a column. | Excel Worksheet Functions | |||
| HOW DO I SORT A COLUMN OF NUMBERS AND HAVE THE DUPLICATES REMOVED | Excel Discussion (Misc queries) | |||
| "Identify numbers in one column and add times from another? | Excel Worksheet Functions | |||
| How do I identify cells with matching numbers within a column. | Excel Worksheet Functions | |||
| identify duplicates | Excel Discussion (Misc queries) | |||
Linear Mode
