| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions
I am looking for a function to look at a column of numbers, select the
largest number, and copy it into another cell. Does such a function exist? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Functions
you might like to explore the opportunities afforded by max
=max(a1:a100) Mike "John" wrote: I am looking for a function to look at a column of numbers, select the largest number, and copy it into another cell. Does such a function exist? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Functions
You can skip the copy, as it will not be necessary. In your destination cell
put the following function: =MAX(A1:A25) Replace the data range with the appropriate range or ranges. Hope this helps... -- Kevin Backmann "John" wrote: I am looking for a function to look at a column of numbers, select the largest number, and copy it into another cell. Does such a function exist? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Functions
Thanks. That did the trick.
"Mike H" wrote: you might like to explore the opportunities afforded by max =max(a1:a100) Mike "John" wrote: I am looking for a function to look at a column of numbers, select the largest number, and copy it into another cell. Does such a function exist? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Functions
Thanks, this worked.
"Kevin B" wrote: You can skip the copy, as it will not be necessary. In your destination cell put the following function: =MAX(A1:A25) Replace the data range with the appropriate range or ranges. Hope this helps... -- Kevin Backmann "John" wrote: I am looking for a function to look at a column of numbers, select the largest number, and copy it into another cell. Does such a function exist? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| XL2003 FILTER FUNCTIONS VS. XL2007 FILTER FUNCTIONS | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Linear Mode
