Run Out Times

[rsgjr1970]

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.

 

[rsgjr1970]

Any thoughts?

 

[John_w]

In cell D2:

=INDEX($G$1:$AD$1,1,MATCH(TRUE,$G2:$AD2<0,0))

entered with Ctrl+Shift+Enter, which puts in { and } around the formula to create an array formula. Then fill down column D for each row.

 

[rsgjr1970]

thank you so much.