Largest Value

  • Thread starter Thread starter o5prey
  • Start date Start date
O

o5prey

Is there a simple way to compare the values in 12 cells, and then retur
the largest value in the 13th cell. I could do this with a complex AND
OR series but there has to be a simpler way
 
If you put =MAX(previous 12 cells) in the 13th cell, you should get th
largest value. Is that what you want
 

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
Finding the largest match 9
DMax with No Criteria 2
Function to lookup largest value 2
Largest value in Col B for each unique value in col A 4
Largest number 4
Largest number 2 3
Largest value cell 2

Back
Top