Grading question

Okay, I'm a teacher and a newbie at this, so hopefully I won't be too confusing. Lets say in column 'A' I had students name. In 'B' I had the score on a test. I want to have a part of this grade sheet that can do a summary. Such as I want it to search column 'B' for any student who got between a 60% and 70%. Then make a list of all students who got that grade. I could be a list, or seperated by commas, whatever. I figured a list would be too hard. Thanks for any help and let me know if you need any clarification.

well a formula could be written, but if a1 contains a header of teacher, and b1 grade, if you w select the header and the range of data, and go to the menu and choose filter autofilter. Now click on the header grade, choose custom then is greater than 60 and below less than 70. they may be greater than and equal to. This list can then be pasted to where you want it

Regards

Dav

I'm sorry, I don't think I explained it right. Lets say I have a list of students. Next to their name, I enter a score they got on a test. I want some kind of list/box/line/whatever that displays kids who got between lets say 60-70%. (ie it automatically looks at each grade, and if it's in the range, pulls the name next to it.

John 80 Students who scored between 60%-70%
Paul 67 Paul, Mary or Paul
Bill 90 Mary
Mary 65

Something like that