View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Jeremy is offline
external usenet poster
 
Posts: 184
Default script or format to identify duplicate data

Is there a way I can write a script or conditional format to identify
duplicate data. The data can be marked by highlight if need be.

Ex
Since A1 and A3 are both the same numbers both locations become highlighted.
I have a large range of data to perform this in. The numbers being
identified are lager than 2 digits.
A
1 12
2 13
3 12


Thank you