+ Reply to Thread
Results 1 to 4 of 4

How to get top 4 results from list to move to next item if it comes across a duplicate

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    Navarre, FL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Cool How to get top 4 results from list to move to next item if it comes across a duplicate

    Hello,

    I have been trying for hours to create a function/formula to help me, please help!

    I have a list of items with associated #'s of units with them, I am arranging into a top 4 list. I am trying to get the associated number of units in the top 4 list matched up with their item using a vlookup/offset/index/matches function and I can't seem to come up with one that will pull the associated item and place it in the cell next to the top 4. Each time the function that I put in their tries to lookup it stops at the first one it comes to. Example:

    Rice 2
    Beans 2


    On top four list:

    2 Rice
    2 Rice

    It won't go down to beans.....

    I attached a sheet for a better example, I can't sort the list above in any difference order.

    Thank you for any guidance!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-03-2010
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    72

    Re: How to get top 4 results from list to move to next item if it comes across a duplicate

    see this link

    http://www.ozgrid.com/Excel/find-nth.htm

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,335

    Re: How to get top 4 results from list to move to next item if it comes across a duplicate

    Pl see the attached file with formula.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-10-2012
    Location
    Navarre, FL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Wink Re: How to get top 4 results from list to move to next item if it comes across a duplicate

    OMG, it was the spreadsheet that blew it out of the park, I have no idea how you came up with that. I was able to copy paste and tweek the -3 to a -1 and it was perfect. Thank you so much, I will be sure to come on here more often and try to help out where I can as well. I really appreciate that response. Thank you again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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