Hi,

I have a formula that looks like the following:

=IF(COUNTIFS(J:J,J15,AM:AM,ABS(AM15),AD:AD,AD15,AX:AX,"<>"AX15)>1,"Duplicate","")

The AX15 will not even register in a color when the "<>" there. I only want the formula to count the rows where the value in AX:AX does not equal AX15. What is wrong with this formula?

Thanks,
Justin