I have identical numbers in one excel, left is old report, right is new report.
Now what I need is the differences between the two sitiuations. So, the difference between left and right.

Left is A -- identical number with right next to it old usage in seconds.

Right is D -- identical number with right next to it new usage in seconds.

What I'm searching is the difference between thise two.

So I need two new collums right next to it or in a new tab with:

every number 1 time with total sec right behind it right minus left

I made an example of the wanted results in G / H / I

Hope someone can help me with this?


oud rapp nieuw rapp draaitabelvb.xlsx