Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
A difficult one for me!!!
A B C D 1 7 3 5 4 2 4 1 3 2 3 ? ? ? ? I have 4 glasses of beer filled with, say 7, 3, 5 and 4 cubic centimeters (row 1) I RANK them from more empty to less empty (row 2, not my question) Now, I have 20 cubic centimeters of beer to fill my glasses, starting from the more empty and finishing in the less empty. If the capacity of a glass is 10 cubic centimeters, what's the formula for row 3 which will give me the beer in each glass after I pour the beer? Please, I'm looking for a formula that does not use any intermediate calculations in other cells. Want to share the beer with me? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
filling up data in blankrows! | Excel Worksheet Functions | |||
help! | Excel Worksheet Functions | |||
filling information from one cell and filling another. | Excel Worksheet Functions | |||
Printing a workbook one row at a time filling in a form with the d | New Users to Excel | |||
In a column with no data, only color filling, how can I filter fo. | Excel Discussion (Misc queries) |