One way
highlight the range. DataSort
HTH


"Panajohn" wrote:

I need to sort matching numbers from a column. For example,

12345 12.00
23456 10.00
34567 8.00
34567 -8.00
45678 6.50
56789 14.50
56789 -8.25
67890 -1.00
67890 -5.00
78901 -2.00
Result
34567 8.00
34567 -8.00
56789 14.50
56789 -8.25
67890 -1.00
67890 -5.00