Hi all

Hoping someone can help - I am creating an evaluation form template and want
just the overall result for a particular set of data ie.

I have listed persons (1-30) across the top row and their response to a
particular question down the first column (Excellent, Very Good, Good, Fair,
Poor). If they reply excellent one gets marked in that cell and the rest of
the cells for that person for that question are blank.

At the end of the row I have a formula to determine the greatest response
i.e. 60% of respondants replied "Excellent", the row which has the
"Excellent" response shows "Excellent" and the other (i.e. Very Good, Good
etc) will show "0" (all using formulas, IF statements etc).

I now need to show the final result to another summary worksheet - any
suggestions for a formula that will get rid of the 0's and show just
"Excellent", "Very Good", "Good", "Fair", or "Poor"? as they could show in
any row in the column relating to the question. I've been at this all day and
nearly given up - there must be a way!

All help hugely appreciated.
Cheers, fdab66.