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!

https://docs.google.com/spreadsheets/d/1XZJcLNkXCT2cq1g5m4ubFFLsiRZGIGFzBEOqbNtlihc/edit#gid=251652063



Related Questions


How to format the time in this Google Docs script

Updated July 12, 2018 14:03 PM

How to Process Rows of Google Sheet Singly?

Updated April 05, 2018 19:03 PM

auto timestamps for multiple column separately

Updated March 25, 2018 11:03 AM