Thread: Honor Roll Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] HappyGilmore@golf.net is offline
external usenet poster
 
Posts: 2
Default Honor Roll Help

Method or formula please :)

In column A I have student names
In column B,C,D (labeled Math, Science, Social Studies) I have their
six weeks grades.
To make "B" honor roll, students may have nothing below an 85 in all
subjects. To make "A" honor roll students may have nothing below a 93
in all subjects.

I can get both honor rolls by sorting for roll "B", then sorting "B"
for "A", but I just know there is a way to do this in one simple
formula.

Appreciate the time and the help.