maximum over a non continuous range
Simple way
=MAX(C5,E5,G5)
if the range will be much larger, try
=MAX(IF(MOD(COLUMN(C5:G5),2)=1,C5:G5))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"david" wrote in message
oups.com...
I want to find the maximum over a non continuous range of cells. I
know how to do it if they are continuous but I don't if they are not.
For instance I want to find the maximum of the values in C5 E5 & G5
but ignore the intervening cells
Help greatly appreciated.
Thanks
David
|