View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default Maximum Value in column

Hi, trying to find a maximum value in a column.
Guesse errors would need to take into account cells that have headerl lines
with text
(need to do numbers only?)

Tried: =IF(ISNUMBER(BI100:BI3000),MAX(BI100:BI3000))
but not quite there yet