I have a very large excel table that appears as follows:
<tbody>
</tbody>I want to delete rows leaving only the row with the max value in column 3
The final table should appear as follows:
<tbody>
</tbody>I am new to VBA and would appreciate any help you could give me.
Bob | OH | 3 |
Bob | OH | 4 |
Bob | OH | 5 |
Mary | OH | 2 |
Mary | OH | 3 |
Mary | FLA | 2 |
Ted | AL | 2 |
Ted | AL | 3 |
Ted | NY | 2 |
Jim | NY | 2 |
<tbody>
</tbody>
The final table should appear as follows:
Bob | OH | 5 | Note: Bob max of 3,4,5 |
Mary | OH | 3 | Note: Mary OH max of 2, 3 |
Mary | FLA | 2 | Note: Mary FLA max |
Ted | AL | 3 | Note: Ted AL max of 2,3 |
Ted | NY | 2 | Note: Ted NY max |
Jim | NY | 2 | Note: Jim NY max |
<tbody>
</tbody>