Guys, I need to do the following thing and I'm struggling with it a bit:
- I have a list of codes (lookup is based on that)
- For each code I need to find Top 5 largest values
- Display each value (top 5)
- Display a name (column name) matching to that value
Lookup needs to be reverse, since it's always going to be done bottom (value) up (heading).
See example attached. Any ideas would be much, much appreciated!