Hi, yes, sorry took so long to reply. 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


"Dave Peterson" wrote:

Do you have any #Ref! errors in that range?

nastech wrote:

Hi, thanks, I thought that should be it, first tried it got a REF error with:

=MAX(BI100:BI3000)

"Michael" wrote:

Hi nastech. Assuming your data is in Column A, in a blank cell type
=Max(A1:A1000). Adjust the range to fit your data. HTH
--
Sincerely, Michael Colvin


"nastech" wrote:

Is there a way to look up a maximum value in a column? thanks.

--

Dave Peterson