software

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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=524621
Is this what you are looking for*?*
=MAX(IF(ISNUMBER(Bi100:Bi3000),Bi100:Bi3000,quot;quot;))--
vane0326
------------------------------------------------------------------------
vane0326's Profile: www.excelforum.com/member.php...oamp;userid=14731
View this thread: www.excelforum.com/showthread...hreadid=524621Hi,

Use the array formula,

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

Confirm with CTRL-SHIFT-ENTER

Regards,
B. R. Ramachandran

quot;nastechquot; wrote:

gt; Hi, trying to find a maximum value in a column.
gt; Guesse errors would need to take into account cells that have headerl lines
gt; with text
gt; (need to do numbers only?)
gt;
gt; Tried: =IF(ISNUMBER(BI100:BI3000),MAX(BI100:BI3000))
gt; but not quite there yet

Thanks, works great...

quot;B. R.Ramachandranquot; wrote:

gt; Hi,
gt;
gt; Use the array formula,
gt;
gt; =MAX(IF(ISNUMBER(BI100:BI3000),BI100:BI3000,-1E 100))
gt;
gt; Confirm with CTRL-SHIFT-ENTER
gt;
gt; Regards,
gt; B. R. Ramachandran
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; Hi, trying to find a maximum value in a column.
gt; gt; Guesse errors would need to take into account cells that have headerl lines
gt; gt; with text
gt; gt; (need to do numbers only?)
gt; gt;
gt; gt; Tried: =IF(ISNUMBER(BI100:BI3000),MAX(BI100:BI3000))
gt; gt; but not quite there yet

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-ENTERquot;vane0326quot; wrote:

gt;
gt; Is this what you are looking for*?*
gt;
gt;
gt;
gt; =MAX(IF(ISNUMBER(Bi100:Bi3000),Bi100:Bi3000,quot;quot;))
gt;
gt;
gt; --
gt; vane0326
gt; ------------------------------------------------------------------------
gt; vane0326's Profile: www.excelforum.com/member.php...oamp;userid=14731
gt; View this thread: www.excelforum.com/showthread...hreadid=524621
gt;
gt;