niteondarun
New Member
- Joined
- Aug 25, 2023
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
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)
=MAX(AZ4,BB4,BD4,BF4,AZ13,BB13,BD13,BF13,AZ22,BB22,BD22,BF22,…,AZ994,BB994,BD994,BF994)