Support Board

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

Date/Time: Thu, 09 May 2024 20:04:16 +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: 3993
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 - 336 views ES 3-5 DayPiv2.scwbf - Attached On 2014-12-16 01:44:38 UTC - Size: 196.57 KB - 330 views