Ranking Numbers

[Nike6106]

Hi

Running into a little problem. I have a data set as follows

A 2
B 2
C 2
D 7
E 8
F 4
G 9
H 10

I am using the function trimmean to find the average of the middle 50%. But I want to know what numbers are contributing to this data. For example, what is the middle 50% of the data ( in the example above, excluding the top 2 and low 2 numbers). I have used the "rank" function, but I fall into problems because there can be multiple #1 ranks, ect.

Any ideas?

[NBVC]

This formula will rank A1:A10 without repeating

=RANK(A1,$A$1:$A$10)+COUNTIF($A$1:A1,A1)-1

copied down

[Nike6106]

thanks, worked great

[NBVC]

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save