Formula for picking the largest number in a column


Posted by Demetra on September 13, 2001 11:08 AM

Hi

I would like to find a formula that will reveiw numerous rows of numbers and pick the largest to place in a cell at the bottom on the column.



Posted by Barrie Davidson on September 13, 2001 11:21 AM

Try using MAX. For example,
=MAX(A1:A45)

Barrie

Barrie Davidson