ExcelBanter - Maximum Value in column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Maximum Value in column (https://www.excelbanter.com/excel-discussion-misc-queries/78548-maximum-value-column.html)

nastech

Maximum Value in column

Hi, yes, sorry took so long to reply. guesse errors would need to take into
account cells that have header lines with text, (need to do numbers only?)

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

All times are GMT +1. The time now is 11:51 PM.