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 |
Solved! Go to Solution.
Thank you in advance!
Hi @Bobbins , shouldn't be any need for an iterative macro, you can accomplish this with just a Multi-Row formula tool:
@FinnCharlton Doh, that would be the simple option wouldn't it!