View Single Post
  #2   Report Post  
Pat Flynn
 
Posts: n/a
Default

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!