Hi all,
I am probably a 3/10 on the Excel literacy scale, and I come looking for guidance from the maestros.
I have some customer data, and I want to return the top purchased product for each individual customer.
Data
Customer Product Purchased Revenue
Customer A Blue 5
Customer B Red 1
Customer C Red 1
Customer A Blue 5
Customer B Red 1
Customer C Green 2
Customer A Orange 20
Customer B Red 1
Customer C Blue 1
Customer A Blue 15
Customer B Red 2
Customer C Gray 2
So, if I have a cell with text Customer A, I would like to have Blue returned in the adjacent cell, since Blue has a net revenue of $25 (greater than Orange at $20)
I know how to do this using helper tables, so I am looking for the coveted SINGLE FORMULA solution.
Excel forum Help.xlsx
Thanks!
John
Bookmarks