Choose lowest text value in a row for excel

Microsoft Office excel 2007 - upgrade
February 14, 2011 at 14:03:20
Specs: Windows XP
I have colums that evaluate different elements ie. "Poor", "Fair", "Good", "Very Good", "Excellent"
In a row, I want to look across all of the columns and return the worst evaluation.
so if one row shows a "Excellent", "Excellent","Excellent" and "Good", my new cell should give an overall grade of "Good".

See More: Choose lowest text value in a row for excel

Report •


#1
February 14, 2011 at 14:32:20
Since a Nested IF statement stops evaluating as soon as it finds a condition that is TRUE, simply list your criteria in ascending order:

This formula should work for A1:E1

=IF(COUNTIF(A1:E1,"=Poor")>0,"Poor",
IF(COUNTIF(A1:E1,"=Fair")>0,"Fair",
IF(COUNTIF(A1:E1,"=Good")>0,"Good",
IF(COUNTIF(A1:E1,"=Very Good")>0,"Very Good",
IF(COUNTIF(A1:E1,"=Excellent")>0,"No Rating")))))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 14, 2011 at 15:05:08
Brilliant-thanks

Report •

Related Solutions


Ask Question