Learn How to Get Max of Every nth Column in Microsoft Excel
The main purpose of this formula is to get the max of every nth column. Here we will learn how to get the maximum value in every column in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the MAX, MOD, and COLUMNS functions using the array formula, you can able to get the max of every nth column.
So, with the help of this formula, you can able to get the maximum value in every column in the given data range in the workbook in Microsoft Excel.
General Formula to Get Max of Every nth Column
{=MAX(IF(MOD(COLUMN(rng)-COLUMN(rng.first)+1,n)=0,rng))}
The Explanation to Get Max of Every nth Column
So we know that with the help of the given formula above, you can able to get the max of every nth column. Here we will learn how to get the maximum value in every column in the given data range in the workbook in Microsoft Excel.
As we know, the formula is using the MOD and COLUMN functions to filter out values not present in the nth columns. After that, it runs MAX on the result. Besides that, the array formula uses the COLUMN function to get a set of “relative” column numbers in the given range.
So now you have learned how to get the maximum value in every column in the given data range in the workbook in Microsoft Excel.