I have a column with the data formatted like this:
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>I am trying to find a code where in the next column or somewhere else, the number that is the largest would show up, but only for that specific letter, so if I was trying to find the largest number from letter L it would be L - 15, and it would show up as that in the other column. And if I were to ask for the largest number for s, it would be S- 11.
Can someone help me?
Thank you.
L-15 |
S-6 |
L-7 |
L-8 |
R-9 |
D-10 |
S-11 |
D-15 |
R-13 |
L-6 |
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
Can someone help me?
Thank you.