Largest Value in a Range

  • Thread starter Thread starter Donna
  • Start date Start date
Assuming you have no qualifying criteria, and you are just looking for the
biggest number
Either
=MAX(A1:A10)
or
=LARGE(A1:A10,1)
 
Thanks. Now what is the formula for finding the largest value and then
inserting $200 in the next column, same row?
 
Donna,

A formula cannot directly change the value in any cell other than the cell
the formula is in so you have 2 choices.

lets assume thes evalues are in a1 down, In B1 enter
=IF(MAX($A$1:$A$100)=A1,200,"")

Or you need a macro.

Mike
 

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

adding largest numbers 2
smallest to largest 9
Conditional Format? 4
Find values across a row and return a text value from the same column 2
News Largest data breach revealed - 773m email addresses and 21m passwords published 12
Second largest value 2
Finding a folder with the largest number. 1
How to determine the value - 18 Dec? 5

Back
Top