•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Return Row Header based on Column Header and value within the table?
Our take
If you're looking to display the top three clients per company from your data table, utilizing the `LARGE()` function is a great start. However, to retrieve the corresponding client names effectively, you'll want to use a combination of the `INDEX` and `MATCH` functions. This approach ensures that you accurately map the highest values to their respective clients. By setting this up on another sheet, you can create a streamlined view that showcases the top clients for each company, enhancing your data insights and decision-making process.
| Company 1 | Company 2 | Company 3 |
|---|---|---|
| Client 1 | 1000 | 2000 |
| Client 2 | 900 | 250 |
| Client 3 | 1400 | 650 |
So basically, i want to display the top 3 clients per company. I was able to get the values by using Large() and have the Company name via Radio Buttons.
I need help with getting the Row Header or the Clients. i might be doing a lookup or index-match incorrectly. i want it to look like below but would be displayed on another sheet. Thank you all!!!
| Top Client | Company 1 |
|---|---|
| Client 3 | 1400 |
| Client 1 | 1000 |
| Client 2 | 900 |
[link] [comments]
Read on the original site
Open the publisher's page for the full experience