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