Excel Averages

W

Weave

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."
 
C

Colin Vicary

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 use
"&COUNTIF(A1:A5)&" times"

Coli
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top