I am trying to use Excel to search a row over a number of columns and return the highest letter-grade in that field. The grades do not follow alphabetical order and some cells have numbers and others letters. The result needs to be displayed on another page in the book.
Any suggestions would be much appreciated.
Any suggestions would be much appreciated.