Challenge! Find top 10 values with a specific criteria

by using, two Software, imagination power V2, mind reader (beta)

I came up with this solution..
In top 10 sheet, E29, use formula as..

Formula:

=LARGE(IF('Data tab'!$C$4:$C$133="turns",'Data tab'!$K$4:$K$133,""),ROW(A1))

by the way .. both above software are still in testing phase.. Please Test.. so that I can launch in market..

Using your posted workbook...
This ARRAY FORMULA, completed by holding down CTRL and SHIFT when you press ENTER (instead of just pressing ENTER) begins the list of highest Turns for the referenced month

Formula:

F29: =LARGE(IF('Data tab'!$C$4:$C$133="Turns",INDEX('Data tab'!$C$4:$P$133,0,$B$2+2)),$D29)

Copy F29 and paste into F30:F38

This REGULAR formula displays the MODEL for each of those highest turns

Formula:

E29: =IF(F29,INDEX('Data tab'!$D$4:$D$133,MATCH(F29,INDEX('Data tab'!$C$4:$P$133,0,$B$2+2),0)),"n/a")

Copy that formula down through D38

With your sample data, these are the results:

1  AVM 6360    4.03572
2  CV-5000     2.87332
3  8685DVB     2.75284
4  CV-6000     1.95634
5  Converter   1.92406
6  CI+ CAM     1.91451
7  CV-7000     1.47501
8  8485DVB     1.32510
9  CV-5000-A   1.15449
10 CV-8000     0.17993

Is that something you can work with?

The quick fix would be to replace the dashes (-) with zeros. The alternative would be less elegant formulas.
Also...since all of the 0's would be tied...the formulas would get really ugly when trying to list them.
Perhaps another approach would be appropriate:
• List all of the MODELS
• Calculate their respective Turns for the selected month
• Use a rank formula that increments ties
• List the ranked MODELS

I could get to that a bit later, there is talent on this forum that could also help.