Largest Value in a Range
 

How do I find the largest value in a range?

Largest Value in a Range
 

Look in the help index for MAX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Donna" wrote in message
...
How do I find the largest value in a range?

Largest Value in a Range
 

Maybe

=Max(A1:a100)

Mike

"Donna" wrote:

How do I find the largest value in a range?

Largest Value in a Range
 

Assuming you have no qualifying criteria, and you are just looking for the
biggest number
Either
=MAX(A1:A10)
or
=LARGE(A1:A10,1)

--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"Donna" wrote:

How do I find the largest value in a range?

Largest Value in a Range
 

Thanks. Now what is the formula for finding the largest value and then
inserting $200 in the next column, same row?

"Mike H" wrote:

Maybe

=Max(A1:a100)

Mike

"Donna" wrote:

How do I find the largest value in a range?

Largest Value in a Range
 

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



"Donna" wrote:

Thanks. Now what is the formula for finding the largest value and then
inserting $200 in the next column, same row?

"Mike H" wrote:

Maybe

=Max(A1:a100)

Mike

"Donna" wrote:

How do I find the largest value in a range?