Support Board

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

Date/Time: Sun, 06 Jul 2025 08:21:06 +0000

Post From: Offset formula in spreadsheet

[2024-04-30 15:55:46] Link To Thread - Link To Post [Go To First Post]
User440951 - Posts: 54
Thanks for your feedback. I followed the example and put the following elements : Y3 : =IF(INT(A3)>INT(A4),Y4+1,Y4) Z3 : =IF(Y3=MAX(Y$3:Y$1002),A3-INT(A3),0) H3 : 09:30:00 H4 : 09:59:59 (Even if you put 10:00:00) H5 : =MAX(INDEX(F$3:F$1002,MATCH($H$4,Z$3:Z$1002,-1),1):INDEX(F$3:F$1002,MATCH($H$3,Z$3:Z$1002,-1)1)) But it doesn't work, it puts me #SYNTAX! ...Even with SUM instead of MAX, as in the example. I also tried putting AA instead of F. Date Time Of Last Edit: 2024-04-30 15:56:52
0x Thank you
2024-04-30 17_42_10.png / V - Attached On 2024-04-30 15:55:35 UTC - Size: 129.99 KB - 78 views