Formula to highlight duplicate but ignore text/word

[tlc53]

Hi,

I have the following formula which almost does what I want it to.

=SUMPRODUCT(COUNTIF(B8:DG22,B8:DG22)-1)>0

However, in the range B8:DG22, which is made up of 5-digit numbers and the word "Blank", I want it to tell me if there's any duplicate entries in the range but ignore the word "Blank" in the formula and not count it as part of a duplication.

Is there a way to amend the code to this?

Thank you

 

[Peter_SSs]

Try this, confirmed with Ctrl+Shift+Enter not just Enter

=IF(MAX(COUNTIFS(B8:DG22,B8:DG22,B8:DG22,"<>Blank"))>1,"Duplicates","No duplicates")