V
vivats
may anyone tell me how to find the largest number within a heap of numbers??
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Rosenfeld
may anyone tell me how to find the largest number within a heap of numbers??
=MAX(Heap)
--ron
L
Lloyd H. London
=max(rangeof heap)
G
Gord Dibben
Assuming the "heap" is a range........
=MAX(A1:A10)
Gord Dibben XL2002
=MAX(A1:A10)
Gord Dibben XL2002
D
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
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
V
vivats
cool, thanks everybody!