Excel formula question

Discussion in 'Trading Software' started by Gordon Gekko, Apr 15, 2003.

  1. Say I have a column of numbers. For example, 5 numbers from A1:A5. What formula can I put in A6 to have Excel find the largest number in the column?

    THANKS
     
  2. Found the answer...

    =LARGE(A1:A5,1)

    :cool:
     
  3. stu

    stu

    =max(a1:a5)

    is good too :)
     
  4. stu

    stu

    Gordon,
    If you want to do a handy fast check for min, max ,sum of numbers etc you could highlight the cells you are interested in then right click the bottom of the excel window frame (should show the word NUM in this area) to select max, min, count,sum etc. for the range you highlighted
     
  5. Thanks for the tips, stu. :cool: