Hello everyone,
I expect this will be something that is very simple, but I am in a pinch and need a resolution to this without me researching. I have a file in column A (ID) I have an account code and each account has multiple ratings Column D. I want to quickly find and select the rows that have the highest value in column D. Some ratings may be duplicated for the account i.e. account 234 may have 4 records with a rating of 8.
Thanks
<colgroup><col><col></colgroup><tbody>
</tbody>
I expect this will be something that is very simple, but I am in a pinch and need a resolution to this without me researching. I have a file in column A (ID) I have an account code and each account has multiple ratings Column D. I want to quickly find and select the rows that have the highest value in column D. Some ratings may be duplicated for the account i.e. account 234 may have 4 records with a rating of 8.
Thanks
ID | Rating |
00000000514 | 5 |
00000000514 | 3 |
00000000514 | 2 |
00000000735 | 9 |
00000000735 | 3 |
00000000735 | 3 |
00000000735 | 3 |
00000000735 | 1 |
00000000927 | 2 |
00000000927 | 2 |
00000001563 | 4 |
00000001732 | 8 |
00000001732 | 8 |
00000001732 | 5 |
00000001732 | 5 |
00000001732 | 5 |
00000001732 | 5 |
00000001732 | 5 |
00000001732 | 5 |
00000001732 | 5 |
00000001834 | 6 |
00000001834 | 6 |
00000001834 | 6 |
00000001834 | 3 |
00000001834 | 3 |
00000001834 | 1 |
00000001834 | 1 |
00000002074 | 9 |
00000002074 | 6 |
00000002124 | 8 |
00000002124 | 8 |
00000002124 | 8 |
00000002124 | 8 |
00000002124 | 8 |
00000002124 | 8 |
00000002124 | 8 |
00000002124 | 8 |
<colgroup><col><col></colgroup><tbody>
</tbody>