Sweetwater
New Member
- Joined
- Jun 6, 2018
- Messages
- 1
Hey Everyone,
First time posting....I'm trying to return the top 5 values that occur in a data dump that match certain criteria that can be dynamically changed.
For Example:
<tbody>
</tbody>
The data is formatted so each row represents one unique entry based on Date, about 100k rows.
In a separate tab with Data Validation you would select a value from column A, B, and C. I would then want to return top 5 most common values in column D based on my selection from the data validation. I'm used to returning a unique value this way based on Index Match, but I would want to return the 5 different values based on that selection.
I hope this makes sense. Please let me know if you have any further questions.
First time posting....I'm trying to return the top 5 values that occur in a data dump that match certain criteria that can be dynamically changed.
For Example:
| ATL | BDL | 040 | 4.99 | |
| ATL | BDL | 040 | 3.99 | |
| STL | BDL | 356 | 20.00 | |
| NYC | BLR | 025 | 14.99 | |
| DET | NTI | 357 | 4.00 |
<tbody>
</tbody>
The data is formatted so each row represents one unique entry based on Date, about 100k rows.
In a separate tab with Data Validation you would select a value from column A, B, and C. I would then want to return top 5 most common values in column D based on my selection from the data validation. I'm used to returning a unique value this way based on Index Match, but I would want to return the 5 different values based on that selection.
I hope this makes sense. Please let me know if you have any further questions.
