Excel Averages
 

I've created a simple excel form using a drop-down list in one column. In
that drop-down list are several choices to pick from (High, medium, low).
There are nine rows using this drop-down list. I want to retrieve an average
in a separate cell. In that average I'm trying to display the text average
and not a numerical average.
i.e. if there are five highs, two mediums, and two lows I want to show an
average that shows "High."

Excel Averages
 

You can use MODE for this.

=MODE(A1:A5)

Or try this for extra features!

="The most common occurence is: "&MODE(A1:A5)&" and it's used
"&COUNTIF(A1:A5)&" times"

Colin


--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472
View this thread: http://www.excelforum.com/showthread...hreadid=488194