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.
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
Last edited by Special-K; 12-07-2017 at 10:03 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
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.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Actually I didn't as I copied the first formula and forgot to change COLUMN() to ROW() :-(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.
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks