Name | Class | Last | New Average | Improve | High Slow | High Timed | X's | |
Ed | Master | 276 | 274 | -3 | 84 | 96 | 4 | |
Mark | Master | 276 | 278 | 2 | 90 | 95 | 5 | |
Steve | Master | 280 | 280 | 0 | 86 | 97 | 5 | |
Nathan | Master | 275 | 271 | -4 | 82 | 97 | 4 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3474;width:71pt" width="95"> <col style="mso-width-source:userset;mso-width-alt:4644;width:95pt" width="127"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3401;width:70pt" width="93"> <col style="mso-width-source:userset;mso-width-alt:804;width:17pt" width="22"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:3913;width:80pt" width="107"> <col style="mso-width-source:userset;mso-width-alt:1097;width:23pt" width="30"> </colgroup><tbody>
</tbody>
High Timed | X's |
97 | 5 |
#NUM! | |
<colgroup><col><col></colgroup><tbody>
</tbody>
Formula is returning #NUM =DGET(A7:L11,"NAME",H38:H39)
I am not having any success trying to complete this scoring program.
I am trying to get the "name" of the person with the highest score. The above formula returns the correct name as long as there are no two scores the same.
In the database above, in column High Timed, there are two scores of 97, but the deciding criteria should be the number of X's
Is there a way to write a formula that would return the name of the person with the highest score, taking into account the number of X's.
The correct return in the above case should be "Steve" not "Nathan"
Than you in advance.