If cell above it contains same data, change formula

[Vincent Thank You]

I've been stuck on this for about a week, I'll do my best to explain what I'm trying to do.

I have column J with the following formula:
=(((G2)+(F2/Q2))-(NETWORKDAYS(TODAY(), I2)/22))

I'm using this formula to tell, based on months of inventory on hand (G2), plus months on purchase order (F2/Q2) and based on a date in column (I2), when the inventory will arrive, how many months on inventory will I have at arrival.

I also have a formula in column H that says, "Alert" if the quantity of inventory I have on hand will run out by said date in column I and that formula looks like this:
=IF((G2*30)<(I2-TODAY()), "ALERT", "")

My issue is that some of the items in this list have multiple purchase orders and therefore multiple lines, one for each PO. I need the formula to recognize the duplicates and take into consideration the inventory on that PO as received and alert or figure the correct months on hand accordingly. I hope his is making some sense to someone. Thanks in advance!

[TABLE="width: 1258"]
<tbody>[TR]
[TD]VENDOR[/TD]
[TD]ITEM #[/TD]
[TD]DESCRIPTION[/TD]
[TD]NET AVAIL[/TD]
[TD]MINIMUM[/TD]
[TD]QTY ON PO[/TD]
[TD]MONTHS ON O/H[/TD]
[TD]ALERTS[/TD]
[TD]EXPECTED DATE[/TD]
[TD]MONTHS O/H AFTER SPMT ARRIVAL[/TD]
[/TR]
[TR]
[TD]OMNICN[/TD]
[TD]JABOBPW[/TD]
[TD]REUSABLE VINYL WHITE[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]215[/TD]
[TD]0.3[/TD]
[TD]ALERT[/TD]
[TD="align: right"]8/30/2019[/TD]
[TD]9.7[/TD]
[/TR]
[TR]
[TD]OMNICN[/TD]
[TD]592APB[/TD]
[TD]WRISTBAND POOL PASS ADULT[/TD]
[TD="align: right"]450[/TD]
[TD="align: right"]2,800[/TD]
[TD="align: right"]1,000[/TD]
[TD]0.3[/TD]
[TD]ALERT[/TD]
[TD="align: right"]8/30/2019[/TD]
[TD]0.4[/TD]
[/TR]
[TR]
[TD]OMNICN[/TD]
[TD]GABOBTRAQ[/TD]
[TD]REUSABLE VINYL AQUA[/TD]
[TD="align: right"]319[/TD]
[TD="align: right"]2,250[/TD]
[TD="align: right"]5,000[/TD]
[TD]0.6[/TD]
[TD][/TD]
[TD="align: right"]8/28/2019[/TD]
[TD]10.3[/TD]
[/TR]
[TR]
[TD]OMNICN[/TD]
[TD]GABOBTRAQ[/TD]
[TD]REUSABLE VINYL AQUA[/TD]
[TD="align: right"]319[/TD]
[TD="align: right"]2,250[/TD]
[TD="align: right"]1,000[/TD]
[TD]0.6[/TD]
[TD]ALERT[/TD]
[TD="align: right"]10/15/2019[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]OMNICN[/TD]
[TD]GABB17OMS[/TD]
[TD]REUSABLE VINYL BLUE/SILVER KIT[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]175[/TD]
[TD="align: right"]240[/TD]
[TD]0.8[/TD]
[TD]ALERT[/TD]
[TD="align: right"]9/20/2019[/TD]
[TD]8.9[/TD]
[/TR]
[TR]
[TD]OMNICN[/TD]
[TD]592ABNG[/TD]
[TD]WRISTBAND POOL PASS ADULT[/TD]
[TD="align: right"]650[/TD]
[TD="align: right"]4,500[/TD]
[TD="align: right"]2,000[/TD]
[TD]0.9[/TD]
[TD][/TD]
[TD="align: right"]8/30/2019[/TD]
[TD]2.9[/TD]
[/TR]
[TR]
[TD]OMNICN[/TD]
[TD]GABOBK4DG[/TD]
[TD]REUSABLE VINYL DARK GREEN KIT[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]100[/TD]
[TD]1.1[/TD]
[TD]ALERT[/TD]
[TD="align: right"]10/11/2019[/TD]
[TD]5.4[/TD]
[/TR]
[TR]
[TD]OMNICN[/TD]
[TD]GABOBTRPW[/TD]
[TD]REUSABLE VINYL WHITE[/TD]
[TD="align: right"]491[/TD]
[TD="align: right"]2,100[/TD]
[TD="align: right"]5,000[/TD]
[TD]1.1[/TD]
[TD][/TD]
[TD="align: right"]8/28/2019[/TD]
[TD]11.5[/TD]
[/TR]
[TR]
[TD]OMNICN[/TD]
[TD]GABOBTRPW[/TD]
[TD]REUSABLE VINYL WHITE[/TD]
[TD="align: right"]491[/TD]
[TD="align: right"]2,100[/TD]
[TD="align: right"]1,000[/TD]
[TD]1.1[/TD]
[TD]ALERT[/TD]
[TD="align: right"]10/15/2019[/TD]
[TD]1.2[/TD]
[/TR]
[TR]
[TD]OMNICN[/TD]
[TD]E15GRE[/TD]
[TD]GREEN ELIMINATOR PET WASTE BOX[/TD]
[TD="align: right"]225[/TD]
[TD="align: right"]1,000[/TD]
[TD="align: right"]1,000[/TD]
[TD]1.2[/TD]
[TD][/TD]
[TD="align: right"]8/21/2019[/TD]
[TD]6.0[/TD]
[/TR]
[TR]
[TD]OMNICN[/TD]
[TD]E15GRE[/TD]
[TD]GREEN ELIMINATOR PET WASTE BOX[/TD]
[TD="align: right"]225[/TD]
[TD="align: right"]1,000[/TD]
[TD="align: right"]750[/TD]
[TD]1.2[/TD]
[TD]ALERT[/TD]
[TD="align: right"]9/27/2019[/TD]
[TD]3.5[/TD]
[/TR]
</tbody>[/TABLE]