Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Largest Value in a Range
How do I find the largest value in a range?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Largest Value in a Range
Maybe
=Max(A1:a100) Mike "Donna" wrote: How do I find the largest value in a range? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Largest of Two Values | Excel Worksheet Functions | |||
Can I calculate a statistical range (largest minus smallest)? | Excel Discussion (Misc queries) | |||
Largest Value | Excel Worksheet Functions | |||
Second largest value | Excel Discussion (Misc queries) | |||
Getting the 2nd largest or smallest valuesin a range | Excel Discussion (Misc queries) |