max number

[vivats]

may anyone tell me how to find the largest number within a heap of numbers??

 

[Ron Rosenfeld]

may anyone tell me how to find the largest number within a heap of numbers??

=MAX(Heap)


--ron

 

[Lloyd H. London]

=max(rangeof heap)

 

[Gord Dibben]

Assuming the "heap" is a range........

=MAX(A1:A10)

Gord Dibben XL2002

 

[David McRitchie]

Sounds like a good time to mention downloading Peter Noneley's
Excel Function Dictionary -- http://homepage.ntlworld.com/noneley
which is an Excel workbook with heaps of functions. Not as good as
heaps of money but better than what I normally think of that may be heaps.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[vivats]

cool, thanks everybody!