View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Weave
 
Posts: n/a
Default Excel Averages III

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