Looping through Data

[Bobbins]

I have the following dataset. You will note that its not in any real order and that this data is added to daily

Cookie Jar Level	Cookie Jar	Date	Customer	Shop
90	Blue	02-Feb-23	Billy	NYC
52	Green	03-Feb-23	Anne	NYC
101	Red	02-Feb-23	George	NYC
55	Blue	05-Feb-23	Salay	Denver
73	Red	05-Feb-23	George	NYC
70	Blue	04-Feb-23	Billy	NYC
42	Green	04-Feb-23	Anne	NYC
65	Blue	05-Feb-23	Billy	NYC
55	Green	01-Feb-23	Anne	NYC
80	Blue	03-Feb-23	Billy	NYC
100	Blue	01-Feb-23	Billy	NYC
85	Red	04-Feb-23	George	NYC

And what I need to create is data that shows the difference between the Cookie Jar Levels for each Date/Date/Customer/Shop. It could be called "Difference".

I should end up with something like this, i guess through some kind of reiterative macro given there could be a whole load of different jars shops and customers

Cookie Jar Level	Cookie Jar	Date	Shop	Difference
55	Blue	########	Denver
100	Blue	########	NYC
90	Blue	########	NYC	10
80	Blue	########	NYC	10
70	Blue	########	NYC	10
65	Blue	########	NYC	5
55	Green	########	NYC
52	Green	########	NYC	3
42	Green	########	NYC	10
101	Red	########	NYC
85	Red	########	NYC	16
73	Red	########	NYC	12

[Bobbins]

Thank you in advance!

[FinnCharlton · Accepted solution]

Hi @Bobbins , shouldn't be any need for an iterative macro, you can accomplish this with just a Multi-Row formula tool: 

[Bobbins]

@FinnCharlton Doh, that would be the simple option wouldn't it!