View Single Post
  #1  
Old February 23rd, 2009, 10:21 PM posted to microsoft.public.excel.newusers
GVPro
external usenet poster
 
Posts: 2
Default 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
........