View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SummerGuy SummerGuy is offline
external usenet poster
 
Posts: 3
Default 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.