+ Reply to Thread
Results 1 to 3 of 3

How to retrieve the largest value of a range..

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-02-2006
    Location
    Love City, USA
    Posts
    183

    Question How to retrieve the largest value of a range..

    Hi,

    I thought this would be a simple answer to find, but I havn't quite
    found a solid answer yet..

    Question, What is the formula to find the largest value in a Range?

    In my case I would like to use a formula that would retrieve the largest
    value in M15:M26.

    Thanks for any help on this..
    Megahertz

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,702
    Try

    MAX(M15:M26)

  3. #3
    Forum Contributor
    Join Date
    07-02-2006
    Location
    Love City, USA
    Posts
    183

    Thumbs up Works Great!

    Thanks daddylonglegs,

    Your formula works great! I appreciate it..

    Big THANKS!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1