Maximum Value in column

N

nastech

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
 
D

daddylonglegs

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

=MAX(BI100:BI3000
 
V

vane0326

Is this what you are looking for*?*



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

B. R.Ramachandran

Hi,

Use the array formula,

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

Confirm with CTRL-SHIFT-ENTER

Regards,
B. R. Ramachandran
 
N

nastech

Thanks, works great...

B. R.Ramachandran said:
Hi,

Use the array formula,

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

Confirm with CTRL-SHIFT-ENTER

Regards,
B. R. Ramachandran
Click to expand...
 
N

nastech

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
 
Top