Urgent Help required

[Krish]

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!!!!!!!!!!

 

[Jim Cone]

Same message is also posted in the Misc group.

 

[Krish]

Sorry i am new user hence forth will not duplicate entries. Will
appreciate the Groups help