are those the correct values in your expected output? for Bank of America, National Association I get Mortgages?
1 of 1 people found this helpful
As in my previous comment, I'm not getting the same numbers you are. Even on the sheet you provided.
But I used RANK() to get the top product for each company. Let me know if this is what you need. I used an LOD calc on top, and your calculation on bottom - for reference.
Thank you Matt! I made up the numbers in my example just so the idea would be conveyed, but I realize I should use the exact numbers to avoid confusion. This was my first submission here so I'm learning the ins and outs.
To be more clear about the goal, I plan to add a few more columns to the table (see the screenshot below). The Top Product would be one of these columns.
It seems like your answer is on the right track for what I'm aiming for, so I'm going through your tab to "reverse-engineer" it to better understand the mechanics.
Thank you again for taking the time to help!
No problem Michael - and welcome to the forums!
if you need more help- just reach out again and we will do our best!