Hi all
I need to extract the rows that store the maximums, by a column
B, between those rows having the same column 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
800000444444 | 1260
800000444444 | 5660
800000444444 | 1260
I want to get a new sheet with
Column A | Column B
800000111111 | 27000
800000222222 | 15000
800000333333 | 9800
800000444444 | 5660
Thanks for help
Tom
Bookmarks