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?
Bookmarks