ExcelBanter - Largest value cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Largest value cell (https://www.excelbanter.com/excel-worksheet-functions/163694-largest-value-cell.html)

Jeff Klein

Largest value cell

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?

Pete_UK

Largest value cell

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

On Oct 26, 7:52 pm, "Jeff Klein" <jklein@nospam 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?

Dave H

Quote:

Originally Posted by Jeff Klein (Post 576588)

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)

All times are GMT +1. The time now is 12:59 PM.