Largest value cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Klein - 26 Oct 2007 19:52 GMT

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?

Reply to this Message

Pete_UK - 26 Oct 2007 20:11 GMT

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

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

Reply to this Message

Dave H - 26 Oct 2007 20:26 GMT

Jeff Klein;576588 Wrote:

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

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

Signature

Dave H

Reply to this Message