N
nastech
Is there a way to look up a maximum value in a column? thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Michael
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
=Max(A1:A1000). Adjust the range to fit your data. HTH
B
B. R.Ramachandran
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
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
K
kraljb
=MAX(A:A) will give you the max value in column
D
Dave Peterson
=max(b:b)
will return the maximum in column B.
will return the maximum in column B.
Is there a way to look up a maximum value in a column? thanks.
N
nastech
Hi, thanks, I thought that should be it, first tried it got a REF error with:
=MAX(BI100:BI3000)
=MAX(BI100:BI3000)
D
Dave Peterson
Do you have any #Ref! errors in that range?
Hi, thanks, I thought that should be it, first tried it got a REF error with:
=MAX(BI100:BI3000)
N
nastech
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
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
N
nastech
Found this answer, seems to work fine, thanks.
=MAX(IF(ISNUMBER(BI100:BI3000),BI100:BI3000,-1E+100))
Array Formula, Confirm with CTRL-SHIFT-ENTER
=MAX(IF(ISNUMBER(BI100:BI3000),BI100:BI3000,-1E+100))
Array Formula, Confirm with CTRL-SHIFT-ENTER
D
Dave Peterson
You'd only need this kind of formulas to avoid errors in that range.
=max() will ignore any cells with text.
=max() will ignore any cells with text.