count if, RIGHT function and conditional format

[Guest]

Hi, I have been using a formula in conditional format to highlight data entry
duplicates in a column

=COUNTIF(F$2:F$500,F19)>1

I am trying to get this to work for a new data set where the last four
digits are the only ones that are unique and maybe are duplicated. I need
to know if any are duplicated.

=COUNTIF(F$19:F$22,RIGHT(F19,4)>1) was the only thing I have thought of so
far, which of course does not work!

Column F
1562222
1252323
1622323


Any help is appreciated, TIA

Todd

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(RIGHT(F$19:F$22)=RIGHT(F19)))>1

 

[Guest]

Thanks Frank. As always I am grateful to your genuis!

Todd