•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?
| 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]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#rows.com
#Excel compatibility
#large dataset processing
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#cloud-based spreadsheet applications
#Client
#Company
#Top Client
#values
#Large()
#lookup
#index-match
#row header
#Radio Buttons
#Excel
#display
#values by company