Excel Quiz Of The Day

[Giggles]

Cheers
It would only be a ‘nice to have’ so I think the 4 can just go on the one page

[Boydy]

View Tweet

[Ben]

The full version.

[Baz]

Porn, that.

[Shindig]

Wearing a suit to eSport

[Bernanke]

I am struggling with a database table where I am trying to compare the quality of three data sources, where one is the "core" one and the other two are being compared against it, since it is set up in an odd way:

id reference source date
1 39.528 1 1 September, 2022, 14:00
2 39.528 2 5 September, 2022, 04:00
3 39.528 3 6 September, 2022, 04:00
4 43.451 1 13 August, 2022, 01:00
5 43.451 2 30 August, 2022, 10:00
6 43.451 3 30 August, 2022, 21:00
7 43.585 1 20 August, 2022, 21:00
8 43.585 2 25 August, 2022, 05:00
9 43.585 3 25 August, 2022, 05:00

I have thousands of rows like this, and I'm trying to compare the average/median time difference of 2 to 1 with the average/median difference of 3 to 1, but I can't figure out how to group them like that in a pivot.

Edit: Writing out a table worked well...

[-james-]

Could you duplicate the reference column, remove duplicates from that, calculate the difference for each source and then average?