# Maximum Value of Alternate Columns/Rows

1. ## Maximum Value of Alternate Columns/Rows

I want to find out the Maximum value of Alternate Columns or Alternate Rows of a range, such as
the maximum Value Column C10, E10,G10, I10 of range B10:I10 - in case of Columns, and
the maximum Value RowC10, M10,M12,M14,M16 of range M9:M16 - in case of Rows.

2. ## Re: Maximum Value of Alternate Columns/Rows

Try
=MAX(IF(MOD(COLUMN(C10:i10),2)=1,C10:I10)
Array formula, use Ctrl-Shift-Enter
=MAX(IF(MOD(ROW(M10:M16),2)=1,M10:M16)
Array formula, use Ctrl-Shift-Enter

3. ## Re: Maximum Value of Alternate Columns/Rows

For Alternate Column.
=MAX(IF(MOD(COLUMN(B10:I10)-1,2)=0,B10:I10))

For Alternate Row.
=MAX(IF(MOD(ROW(M9:M16),2)=0,M9:M16))

Both formula confirmed as array (CTRL + SHIFT + ENTER).

Edit: Special-K beat me to it.

4. ## Re: Maximum Value of Alternate Columns/Rows

Originally Posted by CK76
For Alternate Column.
=MAX(IF(MOD(COLUMN(B10:I10)-1,2)=0,B10:I10))

For Alternate Row.
=MAX(IF(MOD(ROW(M9:M16),2)=0,M9:M16))

Both formula confirmed as array (CTRL + SHIFT + ENTER).

Edit: Special-K beat me to it.
Actually I didn't as I copied the first formula and forgot to change COLUMN() to ROW() :-(
So technically you beat me to to the correct answer :-)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1