If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
Display Modes | |
|
|