Hello,
New guy here, just ran into an problem I can't seem to find the solution to. Any help anyone could provide would be greatly appreciated. Here's my problem:

A B C
1 1111 XXXX 1
2 1111 XXXX 3
3 1111 YYYY 1
4 2222 XXXX 3
5 2222 ZZZZ 3
6 3333 XXXX 1
7 3333 YYYY 1
8 3333 YYYY 2

So if multiple rows match in Column A&B (Like Row 1 and 2) I want to return only the highest of Column C preferrably into a second sheet that would like like this:


A B C
1 1111 XXXX 3
2 1111 YYYY 1
3 2222 XXXX 3
4 2222 ZZZZ 3
5 3333 XXXX 1
6 3333 YYYY 2




So Row 1 and Row 7 from the top sheet have been eliminated since there other rows with matching A and B Columns, but higher values in Column C.


Any ideas?