Maximum Value in Column
Found this answer, seems to work fine, thanks.
=MAX(IF(ISNUMBER(BI100:BI3000),BI100:BI3000,-1E+100))
Array Formula, Confirm with CTRL-SHIFT-ENTER
"Dave Peterson" wrote:
=max(b:b)
will return the maximum in column B.
nastech wrote:
Is there a way to look up a maximum value in a column? thanks.
--
Dave Peterson
|