Hi Darrell,
This is the coward's way out.
1. Give every student an H grade in column AD using

=IF(AC3="","",IF(AC3$AO$12,"A",IF(AC3$AO$13,"B", IF(AC3$AO$14,"C",IF(AC3$AO$15,"D","U")))))

2. Give every student an F grade in column AE using

=IF(AC3="","",IF(AC3$AP$12,"A",IF(AC3$AP$13,"B", IF(AC3$AP$14,"C",IF(AC3$AP$15,"D",IF(AC3$AP$16, "G","U"))))))

3. In column AF use =IF(AA3="H",AD3,AE3) to show the appropriate grade
depending on the students H/F status.

4. You can hide columns AD and AE

NB I've used 79 in AO12, 64 in AO13, 49 in AO14 and 34 in AO15 for the
H grades;
80 in AP12, 70 in AP13, 60 in AP14, 50 in AP15 and 40 in AP16 for the F
grades.

I'm getting kicked off this computer I'll continue later.

Ken Johnson