highest number

  • Thread starter Thread starter jim w
  • Start date Start date
J

jim w

Hi This is my first post.
please could anyone tell me how:)
if i have for instance 7 cells with different numbers in each cell' ie
21' 56' 87' 99' 21' 33' 15' how can i make another cell automaticall
show the highest number from the other cells (in this case the cel
would show number 99.
Thanks
Ji
 
If they're really numbers (not text), then

=max(a1:a7)

and there's an =min() function, too.

And a couple of siblings you may want to read about in excel's help:

=large()
=small()
 
Back
Top