Calculating which students make honor roll

[leahf]

Hi,

I work at a public school and I'm hoping one of you knows if there's a simple way to extract from a data set which students made the honor roll. Right now teachers have to visually scan the printed report cards and report the names of the students who made honor roll to the main office.

Is there an excel function (I'm thinking a pivot table report or a nested if function, maybe?) that can help? I have used these capabilities before but I'm no expert and I haven't been able to figure out how to do it in this example.

Let me describe the data set:

There will be a column with student ID #s, a column with the course name, and a column with the final grade. There will be 7 or so rows for each student.

Honor roll is defined as getting 90 or higher in every class. High honors is defined as getting 95 or higher in every class.

Can I somehow extrapolate ONLY those student numbers for students that made the honor roll and high honors?

I guess it would be something like, if all the values in column A (student ID #) are the same, and all the values in column C corresponding to those same rows (final grade) are greater than or equal to 90, return those student numbers?

Thanks a lot for any guidance you may be able to offer.

Leah

 

[shg]

How about a pivot table?

 

[shg]

Cross-posted at Calculating which students make honor roll

 

[leahf]

I don't understand pivot tables well enough. Is there a good tutorial you can refer me to, or can you help explain how to set up the fields?
Thank you.

 

[leahf]

Hi thank you I did find a solution! Many thanks.