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

Max ignores text values within a range so you should only need

=MAX(BI100:BI3000)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524621

Is this what you are looking for*?*



=MAX(IF(ISNUMBER(Bi100:Bi3000),Bi100:Bi3000,""))


--
vane0326
------------------------------------------------------------------------
vane0326's Profile: http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=524621

Hi, thanks, gave it a try, got same #REF error was getting before.
was given this answer, works pretty good.. later

=MAX(IF(ISNUMBER(BI100:BI3000),BI100:BI3000,-1E+100))
Array Formula, Confirm with CTRL-SHIFT-ENTER


"vane0326" wrote:


Is this what you are looking for*?*



=MAX(IF(ISNUMBER(Bi100:Bi3000),Bi100:Bi3000,""))


--
vane0326
------------------------------------------------------------------------
vane0326's Profile: http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=524621

Hi,

Use the array formula,

=MAX(IF(ISNUMBER(BI100:BI3000),BI100:BI3000,-1E+100))

Confirm with CTRL-SHIFT-ENTER

Regards,
B. R. Ramachandran

"nastech" wrote:

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

Thanks, works great...

"B. R.Ramachandran" wrote:

Hi,

Use the array formula,

=MAX(IF(ISNUMBER(BI100:BI3000),BI100:BI3000,-1E+100))

Confirm with CTRL-SHIFT-ENTER

Regards,
B. R. Ramachandran

"nastech" wrote:

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