I was hoping someone could help me with a formula based on a certain scenario.
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Based on the example above, I would like to write a formula that spits back the number 1 'Product Name' for each 'Organization' based on column 'Total $'.
So, in other words, IF column 'Organization'=American then give me back the largest value in column 'Total $' but return the 'Product Name' as the final output.
My initial swing at this formula was to combine a 'IF' function with the 'INDEX & MATCH' functions and 'large' function in order to give me back the top product name for each organization but I am not having much luck. Any help and insight is much appreciated. Thank you!
Please let me know if you need any clarification.
Organization | Product Name | Total $ |
American | American o | $6,564,132 |
American | American Inc | $3,647,234 |
American | American CIB | $443,245 |
American | American Wash | $523 |
American | American Pc | $4,324,523 |
Franklin | Franklin 1 | $4,523 |
Franklin | Franklin 244 | $4,523 |
Franklin | Franklin 4567 | $432 |
Franklin | Franklin 95654 | $453,244 |
Franklin | Franklin I6 | $45,555 |
Stoneblack | Stoney5 | $45,665 |
Stoneblack | Stoney 982 | $4,241,222 |
Stoneblack | Stoney1 | $1,114 |
Stoneblack | Stoney8 | $42,445 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Based on the example above, I would like to write a formula that spits back the number 1 'Product Name' for each 'Organization' based on column 'Total $'.
So, in other words, IF column 'Organization'=American then give me back the largest value in column 'Total $' but return the 'Product Name' as the final output.
My initial swing at this formula was to combine a 'IF' function with the 'INDEX & MATCH' functions and 'large' function in order to give me back the top product name for each organization but I am not having much luck. Any help and insight is much appreciated. Thank you!
Please let me know if you need any clarification.