Excel formula question

Gordon Gekko · Apr 15, 2003

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

Gordon Gekko · Apr 15, 2003

Quote from Gordon Gekko:

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

Found the answer...

=LARGE(A1:A5,1)

stu · Apr 15, 2003

=max(a1:a5)

is good too

stu · Apr 15, 2003

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

Gordon Gekko · Apr 15, 2003

Thanks for the tips, stu.