Excel Help Again!!! Easy one :)

[The Boosh!]

Done a quick google to no avail

I need a sum that picks out the maximum value from a list of numbers. IE

• 4
• 9
• 3
• 7
• 8

i would need the sum to display number 9 (as its the highest value)

I also need a sum to display the smallest value ( IE 3 from the above.)

Help

 

[Scottydog]

Does this help?

http://j-walk.com/ss/excel/usertips/tip025.htm

 

[Mark One]

=MAX(A1:A10)

=MIN(A1:A10)

simple as that mate

 

[The Boosh!]

=MAX(A1:A10)

=MIN(A1:A10)

simple as that mate

Winner!

Thanks for that... Proper obvious now