Urgent Help required
 

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

Urgent Help required
 

Same message is also posted in the Misc group.

Urgent Help required
 

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

On Oct 11, 9:22 pm, "Jim Cone" wrote:
Same message is also posted in the Misc group.