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

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


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


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

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

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