Keep highest number in cell (threshold)

by AORAION   Last Updated April 16, 2018 01:03 AM

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!

Related Questions

Avoiding an authorization request for google scripts

Updated November 23, 2018 16:03 PM

Which is better: onEdit or onChange trigger?

Updated August 14, 2018 16:03 PM