Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Mon, 12 May 2025 19:11:55 +0000

Post From: Rolling Pivot/Spreadsheet - Shift Issue

[2014-12-16 01:51:42] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4214
Since the session times span two dates, causing the source 1-0-0 chart to have date stamps missing Friday but including Sunday, the overlaid values on the destination charts (which has Fridays and no Sundays) do not track well. If you apply my original INDEX(MATCH()) solution directly on the 0-60-0 charts, with a newer K3 formula for 0-n-0 charts, there is no problem with Mondays. And there is no need to overlay from a 1-0-0 chart. See attached for a comparison. I think the spreadsheet can be made to do what you want.
0x Thank you
ES Cycles2.cht - Attached On 2014-12-16 01:43:52 UTC - Size: 125.88 KB - 453 views ES 3-5 DayPiv2.scwbf - Attached On 2014-12-16 01:44:38 UTC - Size: 196.57 KB - 549 views