Calcuated Value by comparing previous value - Match Index ?

Hi -

Need a help in getting a calculated value by comparing the previous presence.

Please look at the example excel:

Column "H" is my expected values
Whenever column "C" and "D" are 1, Column H should have same value as Column "F"
Whenever column "C" is higher than 1, value in column H should be calculated.
H column should be determined by subtracting the corresponding N+1 value with Nth value

"Whenever column "C" is higher than 1, value in column H should be calculated.
H column should be determined by subtracting the corresponding N+1 value with Nth value"

Can you explain this part in more detail with several examples of the result and how you achieve each result?

h2=IF(D2=1,F2,IF(F2=F1,F2,F2-F1))
try this and copy towards down - it will give result as expected by you.
But you result in column H is not as you explained.

It has to compare the Item-- Column E are the items and I have calculated Column A to get the Unique Items concatenating the Nth Presence.
Please evaluate my expected results in H column. Thanks

The excel I have given Item column is Sorted and the formula you have given is just comparing the above row. How do we handle if the items are not sorted and values in different rows ?