Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: What is the difference between Max() and Large()???

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What is the difference between Max() and Large()???

    I know in Large u can do first largest, second largest and so on, but Max u can't..

    is this the answer i am looking for???

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Basically, yeah, i guess.

    MAX returns the 1st highest of a series, whereas with Large you can specify what position you want, for example of a set of 100 values you can select the 2nd, 3rd, 4th or even 56th highest value of the series, when ranked in order.

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,646
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-13 14:32, LMF wrote:
    What is the difference between Max() and Large()???

    I know in Large u can do first largest, second largest and so on, but Max u can't..

    is this the answer i am looking for???
    MAX(Range)==LARGE(Range,1)

    where == means identical, so the answer is yes.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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