add every second column with formula
 

I want to set a formula that finds the maximum value from every second column
across the whole worksheet. I know column no mod 2 can be used with vba but
how do i incorporate this into a formula.

Thanks

add every second column with formula
 

Either of these two array formulas

{=MAX(--(MOD(COLUMN(B1:IV1),2)=0)*B1:IV1)}
or
{=MAX(--(MOD(COLUMN(B1:IV1),2)=1)*B1:IV1)}

"NDBC" wrote:

I want to set a formula that finds the maximum value from every second column
across the whole worksheet. I know column no mod 2 can be used with vba but
how do i incorporate this into a formula.

Thanks