Maximum Value in Column
 

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

Maximum Value in Column
 

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.

Maximum Value in Column
 

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.

Maximum Value in Column
 

=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

Maximum Value in Column
 

=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

Maximum Value in Column
 

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.

Maximum Value in Column
 

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

Maximum Value in Column
 

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

Maximum Value in Column
 

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

Maximum Value in Column
 

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