add every second column with formula

  • Thread starter Thread starter NDBC
  • Start date Start date
N

NDBC

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
 
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)}
 
Back
Top