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?

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?

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?

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?

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?