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
Bookmarks