software

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

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 Colvinquot;nastechquot; wrote:

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

Hi,

Enter the following formula in any blank cell and ENTER.

=MAX(data_range)

where quot;data_rangequot; is the column range containing your data (e.g., A2:A101)

Regards,
B. R. Ramachandranquot;nastechquot; wrote:

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


=MAX(A:A) will give you the max value in column A--
kraljb
------------------------------------------------------------------------
kraljb's Profile: www.excelforum.com/member.php...foamp;userid=9955
View this thread: www.excelforum.com/showthread...hreadid=523648=max(b:b)

will return the maximum in column B.

nastech wrote:
gt;
gt; Is there a way to look up a maximum value in a column? thanks.

--

Dave Peterson

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

=MAX(BI100:BI3000)

quot;Michaelquot; wrote:

gt; Hi nastech. Assuming your data is in Column A, in a blank cell type
gt; =Max(A1:A1000). Adjust the range to fit your data. HTH
gt; --
gt; Sincerely, Michael Colvin
gt;
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; Is there a way to look up a maximum value in a column? thanks.

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

nastech wrote:
gt;
gt; Hi, thanks, I thought that should be it, first tried it got a REF error with:
gt;
gt; =MAX(BI100:BI3000)
gt;
gt; quot;Michaelquot; wrote:
gt;
gt; gt; Hi nastech. Assuming your data is in Column A, in a blank cell type
gt; gt; =Max(A1:A1000). Adjust the range to fit your data. HTH
gt; gt; --
gt; gt; Sincerely, Michael Colvin
gt; gt;
gt; gt;
gt; gt; quot;nastechquot; wrote:
gt; gt;
gt; gt; gt; Is there a way to look up a maximum value in a column? thanks.

--

Dave Peterson

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 yetquot;Dave Petersonquot; wrote:

gt; Do you have any #Ref! errors in that range?
gt;
gt; nastech wrote:
gt; gt;
gt; gt; Hi, thanks, I thought that should be it, first tried it got a REF error with:
gt; gt;
gt; gt; =MAX(BI100:BI3000)
gt; gt;
gt; gt; quot;Michaelquot; wrote:
gt; gt;
gt; gt; gt; Hi nastech. Assuming your data is in Column A, in a blank cell type
gt; gt; gt; =Max(A1:A1000). Adjust the range to fit your data. HTH
gt; gt; gt; --
gt; gt; gt; Sincerely, Michael Colvin
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;nastechquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Is there a way to look up a maximum value in a column? thanks.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Found this answer, seems to work fine, thanks.

=MAX(IF(ISNUMBER(BI100:BI3000),BI100:BI3000,-1E 100))
Array Formula, Confirm with CTRL-SHIFT-ENTERquot;Dave Petersonquot; wrote:

gt; =max(b:b)
gt;
gt; will return the maximum in column B.
gt;
gt; nastech wrote:
gt; gt;
gt; gt; Is there a way to look up a maximum value in a column? thanks.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

You'd only need this kind of formulas to avoid errors in that range.

=max() will ignore any cells with text.nastech wrote:
gt;
gt; Found this answer, seems to work fine, thanks.
gt;
gt; =MAX(IF(ISNUMBER(BI100:BI3000),BI100:BI3000,-1E 100))
gt; Array Formula, Confirm with CTRL-SHIFT-ENTER
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; =max(b:b)
gt; gt;
gt; gt; will return the maximum in column B.
gt; gt;
gt; gt; nastech wrote:
gt; gt; gt;
gt; gt; gt; Is there a way to look up a maximum value in a column? thanks.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson