Good Afternoon,
I am having trouble coming up with a formula and/or macro and/or array that will work for me. I have about 50 rows of part numbers with inventory and netted demand for the next 24 hours. I want to have a column that shows the run-out time (when the number goes negative), but can't figure it out.
Row 1: Column A (Part Number), Column G:AD (Hourly Intervals - in Military Time)
Row 2: Alpha-Numberic part number, Column G:AD (netted inventory levels, which at some point across the row goes negative)
When it goes negative, I want it to come back in Column D with the Military Time that it goes negative.
Any help would be tremendously appreciated.
Thank you.
I am having trouble coming up with a formula and/or macro and/or array that will work for me. I have about 50 rows of part numbers with inventory and netted demand for the next 24 hours. I want to have a column that shows the run-out time (when the number goes negative), but can't figure it out.
Row 1: Column A (Part Number), Column G:AD (Hourly Intervals - in Military Time)
Row 2: Alpha-Numberic part number, Column G:AD (netted inventory levels, which at some point across the row goes negative)
When it goes negative, I want it to come back in Column D with the Military Time that it goes negative.
Any help would be tremendously appreciated.
Thank you.