Hi all

I need to extract from a workbook the rows who are the maximums, by a field
B, between those having the same field A (numeric, length 12).

I.E:

Field A | Field B
800000111111 | 27000
800000111111 | 4000
800000222222 | 5000
800000222222 | 8000
800000222222 | 15000
800000222222 | 2000
800000222222 | 15000
800000222222 | 9000
800000222222 | 9000
800000333333 | 4500
800000333333 | 2700
800000333333 | 9800

I want to get a new sheet with
Field A | Field B
800000111111 | 27000
800000222222 | 15000
800000333333 | 9800


Thanks for help