Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!!!!!!!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent Help required
Same message is also posted in the Misc group.
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent assistance required for excel | Excel Discussion (Misc queries) | |||
Urgent help required! | Excel Worksheet Functions | |||
Urgent Formula Help Required | Excel Discussion (Misc queries) | |||
Urgent help required! | Excel Discussion (Misc queries) | |||
Urgent help required. | Excel Discussion (Misc queries) |