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!

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

<tbody>
</tbody>