Hi,
I have a spreadsheet with a dynamic range in column A that updates automatically by adding data in the last row. Is it possible to identify “spikes” in the range using formulas in real-time?
For example, in the following range I would like the formulas to return the word “Attention” when...