Functions

[John]

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?

 

[Mike H]

you might like to explore the opportunities afforded by max

=max(a1:a100)

Mike

 

[Kevin B]

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...

 

[John]

Thanks. That did the trick.

you might like to explore the opportunities afforded by max

=max(a1:a100)

Mike

 

[John]

Thanks, this worked.

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...