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?