Max of every nth row and column

[niteondarun]

I am looking to find the max from numbers in every 9th row and every other column in 2016. The tedious way works but hoping for a replacement for this formula:

=MAX(AZ4,BB4,BD4,BF4,AZ13,BB13,BD13,BF13,AZ22,BB22,BD22,BF22,…,AZ994,BB994,BD994,BF994)

 

[JamesCanale]

I hope this can help in 2016:

=MAX(IF((ISEVEN(COLUMN(AZ4:BF994)))*(MOD(ROW(AZ4:BF994)-4,9)=0),AZ4:BF994,""))

 

[niteondarun]

This works Great! Thank you very much! I was able to follow your formula and extend it to capture similar data for all 9 rows by increasing the remainder for each row by 1 from 0 to 8. I was also able to capture the odd rows by using ISODD instead. I compared all of the numbers on a small sample of data and it works great!

Thanks again!