| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highest # in a column A & returns answer from column B Formula | Excel Discussion (Misc queries) | |||
| formula : =(column A)+(column B)-(column C). Why won't it work? | Excel Discussion (Misc queries) | |||
| Formula to look up a column and paste results in another column | Excel Worksheet Functions | |||
| column to column conditional formatting won't work, need formula | Excel Worksheet Functions | |||
| what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Linear Mode
