Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 26 Sep 2024 23:19:23 +0000
Post From: Offset formula in spreadsheet
| [2024-04-30 15:55:46] |
| User440951 - Posts: 50 |
|
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
|
 2024-04-30 17_42_10.png / V - Attached On 2024-04-30 15:55:35 UTC - Size: 129.99 KB - 35 views |