The average true range is a market volatility indicator used in technical analysis. It shows investors the average price range for an investment over a period.
AGGREGATE was built to handle messy data from the start.
Looking for a way to tidy up your spreadsheet and reduce its size without having to use dynamic range formulas like OFFSET, INDEX, or TOCOL? TRIMRANGE detects the cells your data occupies and ...