ExcelBanter - Highest high for a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Highest high for a range (https://www.excelbanter.com/excel-worksheet-functions/134063-highest-high-range.html)

SummerGuy

Highest high for a range

Hi I am trying to calculate the highest high for a range on a rolling basis
eg. the highest high for the past 50 days.

For example, the 50-day resistance level is the highest high in the past 50
days.

All times are GMT +1. The time now is 11:49 AM.