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 Colvin


"nastech" wrote:

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

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.

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

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

Hi,

Enter the following formula in any blank cell and ENTER.

=MAX(data_range)

where "data_range" is the column range containing your data (e.g., A2:A101)

Regards,
B. R. Ramachandran


"nastech" wrote:

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: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=523648

=max(b:b)

will return the maximum in column B.

nastech wrote:

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

--

Dave Peterson

Found this answer, seems to work fine, thanks.

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


"Dave Peterson" wrote:

=max(b:b)

will return the maximum in column B.

nastech wrote:

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

--

Dave Peterson

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

=max() will ignore any cells with text.


nastech wrote:

Found this answer, seems to work fine, thanks.

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

"Dave Peterson" wrote:

=max(b:b)

will return the maximum in column B.

nastech wrote:

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

--

Dave Peterson


--

Dave Peterson