Hi Riny, Many thanks for looking at this. I think my best bet is to not try to get every record individually, and rather just sum the passengers i...
Hi Riny, I've added a worksheet called 'sample', which takes 'Trip ID' number 2 from the TrackingWithStopData Query result, from 21/09/2020. ...
Hi Riny, that's fair - I've added a slightly more close to real life version of some data from a few years ago. The full picture is that withi...
Hi Jeroen, That works well on the sample file, but unfortunately on the real version there's too much data that gets assigned incorrectly when ther...
Riny / Velouria - Both of those options give the expected result. Velouria's option future proof's the formula, which I guess is effectively what you ...
That works perfectly! I am using Excel 365.