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?

  2. Found the answer...


  3. stu



    is good too :)
  4. stu


    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: