I am working on a Google Sheet to track cryptocurrencies, their prices, and their targets. I want to know what the highest target reached was for that particular coin and target range. I have created a column with a formula that will update the last target hit, but I want it to be the highest target hit.
The issue with cryptocurrency is that it is constantly changing 24/7. When the price goes below the targets that have already been hit, the number in the "targets hit" column will go back down.
What I want to do is enable a threshold setting with a Google Script that will keep the highest number (just 1 through 5) in that column. Is this possible? The sheet is linked below. Please reference the yellow row as this has the latest updated formula that I want to keep. Thank you in advance for your help!