Special countif

[daniels012]

I think it is a special countif?
I am just not sure how to do this.
I need to check A13:A280 and make sure there is no no duplicate numbers.

Is there an easy formula to do this? I am sure this is easy, my brain went dead.

 

[MrKowz]

In column B, try:

=IF(COUNTIF(A:A,A1)>1,"Duplicate exists","")

and copy down.

Then filter on column B to show only "Duplicate Exists".

 

[brans1982]

Hightlight range A13:A280 and then in the conditional formatting enter the formula =COUNTIIF($A$13:$A$280,A13)>1 and select e.g. red fill if condtion is true. That will highlight the duplicate numbers.

 

[Aladin Akyurek]

I think it is a special countif?
I am just not sure how to do this.
I need to check A13:A280 and make sure there is no no duplicate numbers.

Is there an easy formula to do this? I am sure this is easy, my brain went dead.

=MODE(A13:A280)

should return #N/A, meaning no duplicates.

 

[brans1982]

=MODE(A13:A280)

should return #N/A, meaning no duplicates.

Thats a handy trick!

 

[daniels012]

Aladin,
That is beautiful. I should have indicated that I did not want to use conditional formatting and use helper cells.
So yours works a charm!

Thank You,
Michael

 

[snoopyhr]

sorry clicked in error