A dummy/newbie needs some help.
My code is not working properly. After manually checking, I see that my code is not working. I can’t figure out what’s wrong.
I am trying to do the following:
1. I am looking at C1:F10 for duplicate numbers.
2. If the cells have one of the following numbers, do not count them—just ignore them:
3. I am looking for duplicates that appear three or more times.
4. If three or more duplicates are found, put “Hot,” and if not put “NH”
Thanks!
My code is not working properly. After manually checking, I see that my code is not working. I can’t figure out what’s wrong.
I am trying to do the following:
1. I am looking at C1:F10 for duplicate numbers.
2. If the cells have one of the following numbers, do not count them—just ignore them:
4, 6, 15, 19, 25, 27, 30, and 33
3. I am looking for duplicates that appear three or more times.
4. If three or more duplicates are found, put “Hot,” and if not put “NH”
Code:
=IF(SUMPRODUCT(COUNTIFS($C1:$F10,"<>4",$C1:$F10,"<>6",$C1:$F10,"<>15",$C1:$F10,"<>19",$C1:$F10,"<>25",$C1:$F10,"<>27",$C1:$F10,"<>30",$C1:$F10,"<>33")-2)>0, "Hot", "NH")
Thanks!