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

Interesting situation help required!!
 

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

Interesting situation help required!!
 

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


Replace @mailinator.com with @tiscali.co.uk


"Krish" wrote in message
ups.com...
Please help!!!!!!!!!!

Interesting situation help required!!
 

http://linux.sgms-centre.com/misc/ne....php#impatient
--
David Biddulph

"Krish" wrote in message
ups.com...
Please help!!!!!!!!!!