D
Donna
How do I find the largest value in a range?
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.
D
Don Guillett
Look in the help index for MAX
M
Mike H
Maybe
=Max(A1:a100)
Mike
=Max(A1:a100)
Mike
J
John C
Assuming you have no qualifying criteria, and you are just looking for the
biggest number
Either
=MAX(A1:A10)
or
=LARGE(A1:A10,1)
biggest number
Either
=MAX(A1:A10)
or
=LARGE(A1:A10,1)
D
Donna
Thanks. Now what is the formula for finding the largest value and then
inserting $200 in the next column, same row?
inserting $200 in the next column, same row?
M
Mike H
Donna,
A formula cannot directly change the value in any cell other than the cell
the formula is in so you have 2 choices.
lets assume thes evalues are in a1 down, In B1 enter
=IF(MAX($A$1:$A$100)=A1,200,"")
Or you need a macro.
Mike
A formula cannot directly change the value in any cell other than the cell
the formula is in so you have 2 choices.
lets assume thes evalues are in a1 down, In B1 enter
=IF(MAX($A$1:$A$100)=A1,200,"")
Or you need a macro.
Mike