Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
I have a table that looks like this: ---------------------------- A B C D E 1. 8 2. 6 3 4 3 2 3. Output: 3 --------------------------- The output value should show the number of columns (starting from E2 going to the left) it takes to add until the value (of the figures in row E) is higher than E1. In this case that would be 2 + 3 + 4 8, therefore the output would be 3. If E1 is 13, then the output would be 5, etc. This formula is used to calculate the number of months of expenses to replace an inventory figure. Thanks for your time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count the number of values when two conditions are met | Excel Worksheet Functions | |||
Count of Number Values Greater Than, Less Than | Excel Worksheet Functions | |||
Sound For Calculated Number Exceeding Limit | Excel Discussion (Misc queries) | |||
Count number of values | Excel Worksheet Functions | |||
Count number of Unique values | Excel Worksheet Functions |