View Full Version : [SOLVED:] Cumulative based of criteria
technician12
08-11-2022, 03:56 AM
Hi,
i'm trying to find a way to calculate some cumulative values based on some criteria, if anyone know a solution i'd very much appreciate it
arnelgp
08-11-2022, 05:22 AM
here check the formula.
technician12
08-11-2022, 05:55 AM
works perfectly except:
https://imgur.com/a/81jKBhi
Edit: values should only be "kept" if at the point of a series going up by an incriment
arnelgp
08-11-2022, 06:39 AM
i made a function.
see module1.
also check the syntax on "new" column.
technician12
08-11-2022, 10:47 PM
Sadly i'll have to do this without the use of any Macros or VBA, as for some reason it causes complications with the device pulling this information
arnelgp
08-11-2022, 11:54 PM
check this again, if still not the answer, somebody will give you the correct one, i'm sure.
technician12
08-12-2022, 03:51 AM
You're a legend, Thank you!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.