Most Common Values Matching certain criteria

[Sweetwater]

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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]ATL[/TD]
[TD]BDL[/TD]
[TD]040[/TD]
[TD]4.99[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ATL[/TD]
[TD]BDL[/TD]
[TD]040[/TD]
[TD]3.99[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STL[/TD]
[TD]BDL[/TD]
[TD]356[/TD]
[TD]20.00

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NYC[/TD]
[TD]BLR[/TD]
[TD]025[/TD]
[TD]14.99[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DET[/TD]
[TD]NTI[/TD]
[TD]357[/TD]
[TD]4.00[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.

 

[DRSteele]

Welcome to the forum.