Support Board

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

Date/Time: Tue, 26 Nov 2024 05:56:50 +0000

Post From: Maximum If Value is Greater than 0 (Spreadsheet System for Trading)

[2024-01-06 17:24:19] Link To Thread - Link To Post [Go To First Post]
User827002 - Posts: 36
In column Q in the screenshot I've attached, I'm trying to develop a formula to find the maximum of column P, only until the next 0. In other words, the maximum of each sequence of consecutive numbers in between zeros. So Q3 should show 4738.5, Q4 should show 4738.5, Q5 should show 4737.5. Q6:Q8 should show 0, Q9 should show 4730.5, Q10:Q15 should show 4728.5. Do you have any recommendations?
0x Thank you
Maxofsegment.PNG / V - Attached On 2024-01-06 07:25:42 UTC - Size: 14.63 KB - 54 views Attachment Deleted.