Hi All,

I've grades of each student for each subjects in a row from cell 'A' - 'F'
and I want to display their least grade in a subject in cell 'G'. that is If
a person is in C grade in any one of the subject I want "C" to be displayed
in "Least Grade" column. Is there a formula to get the desired result?

Example

Sub - 1 Sub - 2 Sub - 3 Sub - 4 Sub - 5 Sub - 6 Least Gr
John A B A B A C C
Anna B A B A B B
Steven A A A A A
Mary A B A B A C C


Thanks for your help.

--
Karthi