Well I figured out the problem. I was using the mode function on cells that
were calculated using a formula. I guess it didn't like that.

"Pat Flynn" wrote:

If the data set contains no duplicate data points, MODE returns the #N/A
error value.
Does your data contain duplicate data points? If not you want to look for
MEAN or MEDIAN.
Else post an example for us to look at.
Regards,
Pat

"vmagal1" wrote:

When I try to use the mode function on a set of values, I get #N/A back as my
answer. Please help!