Step 1: I have range of numbers lets say 50, 25, 30 and so on....

Step 2: I want to find 10% of of the range in above ex 5, 2.5, 3...

Step 3: The numbers to be rounded of to 5,3,3.......

The following will help for first 3 steps i.
=Round(CountA("Range")*10%),0)

Step 4: Now the tricky situation

a) Specific to the range as in above ex for range with 50 numbers the
result shoulbe the Average of the highest 5 numbers, Lowest 5
numbers, Average of the range;

b) for range with 25 numbers the result shoulbe the Average of the
highest 3 numbers, Lowest 3 numbers, Average of the range

c) for range with 30 numbers the result shoulbe the Average of the
highest 3 numbers, Lowest 3 numbers, Average of the range



I have around 61 different ranges in this fashion in different columns
(no named ranges)

Please help!!!!!!!!!!