| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest number 2
I have a range of cells with a number in each cell (below).
Cell C1 2 Cell C2 12 Cell C3 14 Cell C4 7 I want a formula that gets the largest number in Cell C1. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Largest number 2
=MAX(C1:C4)
If this post helps click Yes --------------- Jacob Skaria "MAX" wrote: I have a range of cells with a number in each cell (below). Cell C1 2 Cell C2 12 Cell C3 14 Cell C4 7 I want a formula that gets the largest number in Cell C1. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Largest number 2
In C1 enter:
=MAX(C2:C4) -- Gary''s Student - gsnu200850 "MAX" wrote: I have a range of cells with a number in each cell (below). Cell C1 2 Cell C2 12 Cell C3 14 Cell C4 7 I want a formula that gets the largest number in Cell C1. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Largest number 2
Hi Max
Type this =MAX(C2:C100) in C1, change range to your needs HTH John "MAX" wrote in message ... I have a range of cells with a number in each cell (below). Cell C1 2 Cell C2 12 Cell C3 14 Cell C4 7 I want a formula that gets the largest number in Cell C1. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Largest number | Excel Worksheet Functions | |||
| Largest Prime Number | Excel Discussion (Misc queries) | |||
| Finding the largest number help | Excel Discussion (Misc queries) | |||
| highlight largest number in a row | Excel Worksheet Functions | |||
| finding the largest number from the last row and look up its name. | Excel Worksheet Functions | |||
Linear Mode
