View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DMS DMS is offline
external usenet poster
 
Posts: 9
Default 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?