Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lowest value in top 80% of Total?
Excel 2000 ... What I have
# of records ... <5000 Col AS ... Formulas producing random numeric values (0 to 20,000,000) I would like a Formula (Cell AT2) to produce the lowest value found within the top 80% Volume Total of Col AS. To do this manually I: Sort Col AS Descending Select all values in Col AS to determine Total Sum Use calculator ... (Total Sum)*(.8)= 80% Volume Total Select all values in Col AS down to 80% Volume Total Obtain lowest value from this range Use above value in another formula If I could make this happen with a formula in a single cell ... then I could reference this cell with my formulas rather than always having to determine & use hard values. Thanks ... Kha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
Total remaining formula | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions | |||
Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions |