How can I find the maximum values on column B that correspond to unique IDs on column A? I can't use a pivot table as there are way too many IDs. For example:
Column A --------- Column B ------- Column C
11452 --------------- 1 ---------------- 5
11452 --------------- 2 ---------------- 5
11452 --------------- 5 ---------------- 5
11452 --------------- 4 ---------------- 5
534 ------------------- 2 ---------------- 9
534 ------------------- 2 ---------------- 9
534 ------------------- 5 ---------------- 9
534 ------------------- 9 ---------------- 9
99843 ---------------- 1 ---------------- 3
99843 ---------------- 2 ---------------- 3
99843 ---------------- 3 ---------------- 3
The ideal formula would be one that gave me column C. I've tried using MAX(IF but there are way too many IDs. Is there any formula that I can just drag down?
A non VBA solution would be highly appreciated.
Thanks
Bookmarks