Largest value cell

J

Jeff Klein

I have a spreadsheet with many numbers and I would like to have a cell that
shows the largest value of all the cells. Any ideas?
 
P

Pete_UK

You can't include the cell where the formula is in the range of cells,
but just use this in A1:

=MAX(A2:M1000)

Adjust the range to suit your data.

Hope this helps.

Pete
 
D

Dave H

Jeff said:
I have a spreadsheet with many numbers and I would like to have a cell
that
shows the largest value of all the cells. Any ideas?
Click to expand...

=max(range) ie: =max(a1:a3)
 
Top