I need a formula that rank using excel, will allow me to rank highest degree type obtained by students. some students have multiple (masters, bachelors), but this varies person by person. so the two fields i have are name and education degree type
Solved by I. W. in 20 mins