Would anyone give some insight as to how Excel calculates modes? For example, if there is only 1 value, or if there are only 2 distinct values (that rank the same)? I have something that looks like this
=MODE(IF($E:$E=H$1,IF($F:$F=$A2,$G:$G)))
However, if there is only 1 value I am not getting an #N/A. Is there something I can add to this to bring back an occurrence of any value? I have a lot of #N/A's in my data set and I am trying to bring back a value if possible.
=MODE(IF($E:$E=H$1,IF($F:$F=$A2,$G:$G)))
However, if there is only 1 value I am not getting an #N/A. Is there something I can add to this to bring back an occurrence of any value? I have a lot of #N/A's in my data set and I am trying to bring back a value if possible.
