I have a list of grades that's around 100 people long, from A, A-, B+....F, what function do I use to find the lowest, highest and median grade letter?
To find highest its =max(cellref:cellref) to find lowest, its =min(cellref:cellref).
It might also be an idea though to sort into grades and then you can do a count of how many in each group.