Hello people, I'd like to check up on something that I think that I already know the answer, but I wanna at least have some confirmation before I can eventually abandon my hopes and move forward.
Here's the situation: I want to come up with a formula that can automatically set the "highest score" that was ever found in a sheet. How's that supposed to work? Well, let's say that, for instance, there's that well known counter of how many days a certain business has gone through without having any kind of accident / incident, right? Ok, until that part we're game, the counter works just fine with the Max function, always subtracting the present day from the latest date of occurence. The thing is that I want to create a criteria to estabilish a parameter to be surpassed, like "The best score so far was 60 days", so when you reach 61, that number is changed automatically and a new record is therefore estabilished.
I'm pretty sure that it's definitely possible to achieve that through VBA, but before I start researching how to get that kind of result, I'd first like to know if that could ever be achieved through the regular Excel formulas.
By the way, thank you for taking your time to read through all this,
Zenarte
Bookmarks