C
Cheryl
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?
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?