excel formula does not equal?Advertisement
Is there an argument like F5=39 where I could say F5 "DOES NOT EQUAL" 39? Is there some operator that can do that? How would I accomplish that without creating an AND() argument? ... Plus Sign After Equal Sign in Excel Formula? How do I find equal values across 2 different columns in ... - read more
Best Answer: this is "not equal" "<>" If it will not work in the "countif" criteria then put it a n "if " formula in its own column referring to your data e.g if data <> to 0 then "1" else "0". Then use the "1" in the new column as the criteria i.e "=1" - read more
Please vote if the answer you were given helped you or not, thats the best way to improve our algorithm. You can also submit an answer or check other resources.