View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cheryl Cheryl is offline
external usenet poster
 
Posts: 144
Default Compare Figures in a Column


I need to take a column over 5000 rows long and find out which control
numbers are duplicated. I have tried =COUNTIF($C$2:$C$5000,C2)1 as an
array in conditional formatting, but it didn't work. If it had worked this
would have been perfect to highlight all duplicated numbers.

Can someone tell me what I did wrong here?
--
Cheryl