Ranking criteria

[asmoghal]

how can i select top two & bottom two values out of 13 values with a conditioned (value should be greater than or less than 0), in other words if any value is equal to zero, formula should disregard that value.

The 13 values are generated by automated drop down list, so each time if i change parameters from drop down list option it gives 13 different values

for example for top one if can use =Maxa(......)

INDEX Q2-YEAR 1
1 1,074,413
2 1,702,710
3 1,043,185
4 766,903
5 1,038,176
6 837,402
7 986,306
8 1,928,851
9 1,452,903
10 1,935,202
11 963,209
12 -
13 -

[TMS]

You can use SMALL and LARGE to select these values.

Regards

[asmoghal]

Thanks Man, Bravo