Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Finding the secomd maximum number in a list

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

    Default

    I have a colum of numbers in which i want to find the second max number in and then multiply that number by 2.

    thanks for the help

    and have a happy easter


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

    Default

    On 2002-03-29 04:26, drag-driver wrote:
    I have a colum of numbers in which i want to find the second max number in and then multiply that number by 2.

    thanks for the help

    and have a happy easter
    =2*LARGE(A2:A100,2)

    where A2:A100 houses the numbers of interest.

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

    Default

    I continually learn new tricks from you guys, tytytytytyty

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
  •