Look for formula to subtract columns based on another columns Value

IF

IF(Logic,True,False)

Logic = D133="Example 1"
True = F133-H133
False = ? What do you want to happen, keep all of F... then F133

However - how does it know it know "Same Values" are you saying if it has more than 1, then take quantity - received?

Logic would need to be Countifs(D:D,D133)>1
Which is to say if this Probill exists more than just now, move to TRUE otherwise move to FALSE

If everything is assumed correctly... this should go into I133

Please Login or Register  to view this content.

Image did not come through...

But what you are describing is that H contains a 3 as does F?

The formula previously provided should do this UNLESS, this is not a "Multiple" entry based on that Probill ID...

If there is no difference between the operation of when there is multiples and is not... would not simply saying F - H = I?

So Column I should be a floating summary (Running Total of Remaining)

In that case this changes the structure.

This says give me the Total Quantity Up through current row - Total Quantity Received up through current row.

Please Login or Register  to view this content.

Now, is your Quantity repeated always (Appears to be) but is it the same value throughout the document...

Example 1 every time it appears will ALWAYS have 5? or is that subject to change through time?

If it is always the same and we are trying to say what do they have left...

In that case, lets get the MAX quantity issued minus running total of received

Please Login or Register  to view this content.

We can also say get the MAX ever issued up till NOW (Current Row) and remove what has been issued up till now... this way if that 5 for Example 1 changes to 6 40 records later, it will add the 1 to the issued when the time comes
=MAXIFS($F$3:$F3,$D$3:$D3,$D3)-SUMIFS($H$3:$H3,$D$3:$D3,$D3)