View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default 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