Rolling 52 week high

My formula in col_C to find rolling 52 week high returns #N/A. Any alternative formula or revised formula to find rolling 52 week high?

Try

=IFERROR(INDIRECT("F"&MATCH(A251-364,A:A,0)&":F"&ROW()),"")

There is no real problem with your formula, it's the data! I think your formula is failing because there are a few dates MISSING from the previous year.

On row 6/7, you jump from 5/10/1928 to 8/10/1928. Also missing dates on rows 10/11, 15/16, and 20/21.

When you go back 365 days to these days, you get N/A error.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Hi
I use YEAR.ISOWEEKNUM.WEEKDAY to match data and if error a correspondent day of the past year.
Use the formula in C251 e drag down

Formula:

=INDEX($F$2:$F$312,IFERROR(MATCH(YEAR($A251)-1&MID(YEAR($A251)&"."&ISOWEEKNUM($A251)&"."&WEEKDAY(A251),5,5),

INDEX(YEAR($A$2:$A$312)&"."&ISOWEEKNUM($A$2:$A$312)&"."&WEEKDAY($A$2:$A$312),0),0),MATCH(EDATE($A251,-12),$A$2:$A$312,0)))

Thanks all experts. My job finished.