Interesting situation help required!!

  • Thread starter Thread starter Krish
  • Start date Start date
K

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!!!!!!!!!!
 
See your other thread in Microsoft.Public.Excel. Please don't multi-post,
most regulars read all NG's and muli-posting causes fragmented answers and
wasted effort.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top