Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Simple formula??? (Win98/Office 2000 sp1)

    Hi There,

    I need a formula that returns the highest value in a range of cells, I could write some code to do this however im sure there is any easier way using an excel function. I just havent been able to get any of them to work.

    If anyone could help, it would be greatly appreciated.

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Simple formula??? (Win98/Office 2000 sp1)

    How about the MAX function, as in:

    =MAX(A1:A100)

    to find tha largest value in the range A1:A100.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Lounger
    Join Date
    Apr 2003
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Simple formula??? (Win98/Office 2000 sp1)

    Thanks for that, I knew it was something simple......

    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •