| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and Highlight duplicates in 5 non-adjacent columns
I have series of serial nnumbers in five non-adjacent columns.
Ineed to find, and, if possible, highlight them. I am using Excel 2003 at work and 2007 at home. EX: A B C D E F G H I J 1 31686 ....... 21213 ....... 37801 ....... 55555 ....... 78613 ........ 2 37814 ....... 80081 ....... 67766 ....... 54455 ....... 84400 ........ 3 55555 ....... 60550 ....... 41223 ....... 10002 ....... 27177 ........ 4 43477 ....... 77772 ....... 43434 ....... 94867 ....... 29525 ........ 5 69362 ....... 24543 ....... 55555 ....... 99323 ....... 63122 ........ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Duplicates Rows Based Own Multiple Columns | Excel Discussion (Misc queries) | |||
| How to find and highlight common text in multiple columns | Excel Discussion (Misc queries) | |||
| compare two columns within a worksheet, then highlight duplicates | Excel Worksheet Functions | |||
| List date adjacent to duplicates? | Excel Worksheet Functions | |||
| Compare data in two columns to find duplicates. | Excel Discussion (Misc queries) | |||
Threaded Mode
