I'm looking for a way to identify the highest valued Job ID (Column B) for each of the Incident Numbers (Column A). I need to flag the row with the highest value so that I can easily delete the other rows. Rows to keep are in Green.
Here is the data:
Column A Column B
<tbody>
</tbody>
Here is the data:
Column A Column B
Incident Number | Job Id | NAME | CURRENT_STAT |
548234 | 1237479 | 06.005 CRAFT RD (914) - RE | Retrieved |
548234 | 1237353 | 06.005 CRAFT RD (914) - RE | Retrieved |
548234 | 1179216 | 06.005 CRAFT RD (914) - RE | Retrieved |
580870 | 1460187 | 07.002 KINGSTON ST (3089) - RE | Retrieved |
580870 | 1450542 | 07.002 KINGSTON ST (3089) - RE | Retrieved |
580870 | 1385586 | 07.002 KINGSTON ST (3089) | Retrieved |
<tbody>
</tbody>