Delete cell/adjacent value & keep the largest number

[Allysa]

Here's an example of the Excel table I've got (it's two columns):

<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;">1631823842 1
1631823842 2
1631823842 3
1631823853 1
1631823853 2
1631823859 1
1631823859 2
1631823859 3

</code>What I'm trying to figure out is how to delete all the duplicates EXCEPT the largest. So I'd be left with:

<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;">1631823842 3
1631823853 2
1631823859 3

How can I accomplish this with Excel?
</code>

 

[sheetspread]

Sort ascending 1st col, descending 2nd, then advanced filter, unique records (in place)