Largest value cell

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
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?
 
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula (or code) return the largest number of duplicates in a list. 16
Largest number 4
Largest number 2 3
News Largest data breach revealed - 773m email addresses and 21m passwords published 12
Lookup query 3
Is this function supposed to work? 6
DMax with No Criteria 2
displaying 1st, 2nd, and 3rd in one cell 2

Back
Top