| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add column until capacity is met
I have a column with different volume amounts and I have a volume capcity for
each day of the week (Sat - 25K, Sun - 50K.....) I need to depict which volume I will be working on each day. I want to keep adding the volume column until I reach my goal and next to the volume column it should display (Saturday). However, if the current total for Saturday is 24,000 and the Cap is 25K and the next volume is 2K, it should skip over it because that would but Saturday over the cap and look for a volume that is below 1K....Does this make sense? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
