+ Reply to Thread
Results 1 to 7 of 7

Formel for top 3

  1. #1
    Registered User
    Join Date
    07-25-2014
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2010
    Posts
    8

    Formel for top 3

    I need a formula to make a top 3
    Top 3 is in R3, R5 and R7. I need a formula that takes the 3 highest values ​​in row 9 and then take the names in the same column and write them in R3, R5 or R7.

    Does it make sense?

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Formel for top 3

    The large formula does what you want.

    http://chandoo.org/excel-formulas/large.shtml


    =Large(YourList,2)



    I cant assist with bringing you the name associated with the number because you didnt post a sample dataset.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    07-25-2014
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2010
    Posts
    8

    Re: Formel for top 3

    Thanks Mike.

    Just found the way to upload the sheet.
    Attached Files Attached Files
    Last edited by R.Gaard; 07-25-2014 at 04:18 PM.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Formel for top 3

    yikes, that seems awfully difficult to deal with, why not have a standardized dataset in the background then reporting on this tab?

    Anyway, How do you find the top 3 largest when you have 7 ties for the largest?

  5. #5
    Registered User
    Join Date
    07-25-2014
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2010
    Posts
    8

    Re: Formel for top 3

    I dont know what you mean..

    If there are ties, I want all names of those who are ties in the same cell. If its possible.

  6. #6
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Formel for top 3

    It is possible, but the data layout is horrible and will mean way more work than if you standardized it in a tidy manner in the background.

    Typically it is best to have a data tab, then some sort of reporting on top of that data. This keeps things much easier to manipulate and report on. With this, you could use a pivot table using excel's native features to do exactly what you want in under 15 seconds. The current layout creates much more overhead for you and any clever formulas you want.

  7. #7
    Registered User
    Join Date
    07-25-2014
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2010
    Posts
    8

    Re: Formel for top 3

    okay. I have no idea how to do that. Im not use to work that much inside excel. I mostly use it for importing to economic programs and other simple formel and calculations.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [DEUTSCH] Probleme bei der Findung der richtigen Formel
    By Furyios in forum Non English Excel
    Replies: 1
    Last Post: 05-07-2014, 10:27 AM

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