Guessing here....

With High's, Medium's, and Low's dispersed in cells A1:A10,
Is this what you're looking for?
=CHOOSE(ROUND(AVERAGE(MATCH(A1:A10,{"High","Medium ","Low"},0)),0),"High","Medium","Low")

Note: Confirm that array formula by holding down [Ctrl] and [Shift] when you
press [Enter].

Does that help?

***********
Regards,
Ron


"Weave" wrote:

I'm trying to get an average on high, medium, and low values whereby the
values are displayed in text. There is only one text value listed per cell
for about 9 rows. I need the average results displayed in text. (i.e.
A1=high, A2=medium, A3=low, etc.). In a separate cell I need the average of
highs-lows displayed in the words, "high", "medium", or "low" (w/out the
quotations).