+ Reply to Thread
Results 1 to 10 of 10

Look up to return in order highest to lowest

  1. #1
    Registered User
    Join Date
    11-18-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    88

    Look up to return in order highest to lowest

    I have a list of items in B3-B15 and in C3-C15 the number of each item

    In E3 and E3 i would lover the items and number of items in highest order, please

    Sheet attached.
    Attached Files Attached Files
    Last edited by TrainerJ; 11-16-2017 at 07:47 AM.

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Look up to return in order highest to lowest

    Why not simply sort range B3:C15 ?
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    11-18-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    88

    Re: Look up to return in order highest to lowest

    This range will change often so want the E3 and E4 to be consistent if that makes sense.

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,524

    Re: Look up to return in order highest to lowest

    Quote Originally Posted by TrainerJ View Post
    This range will change often so want the E3 and E4 to be consistent if that makes sense.
    reattach the file with expected result
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  5. #5
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: Look up to return in order highest to lowest

    I'm not sure what you're asking. Do you want the list automatically sorted in columns E and F? (That is, did you mean cells E3 and F3?)
    Clicking the Add Reputation star below any helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion. (Thread Tools above Post # 1) Thanks!-Lee

  6. #6
    Registered User
    Join Date
    11-18-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    88

    Re: Look up to return in order highest to lowest

    Iv changed the document to show what I would like

    thanks again
    Attached Files Attached Files

  7. #7
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Look up to return in order highest to lowest

    A very simple way would be to use a pivot table, which you can then simply refresh when your source data changes.
    Attached Files Attached Files

  8. #8
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: Look up to return in order highest to lowest

    Paste this in E3 and copy down:
    Please Login or Register  to view this content.
    Paste this in F3 and copy down:
    Please Login or Register  to view this content.
    Last edited by leelnich; 11-17-2017 at 07:15 AM.

  9. #9
    Registered User
    Join Date
    11-18-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    88

    Re: Look up to return in order highest to lowest

    Perfect thank you

  10. #10
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: Look up to return in order highest to lowest

    You're most welcome, thank you for the rep!

+ 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. [SOLVED] Sorting from highest value to lowest and return name and not value
    By thedrinkerparadox in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-16-2017, 12:04 PM
  2. Help verifying worksheet names are in order lowest to highest
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2017, 04:31 PM
  3. [SOLVED] Ranking order based on highest to lowest value
    By Pranuvins in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-29-2016, 04:10 AM
  4. [SOLVED] Highest And Lowest Score Order
    By StickCity in forum Excel General
    Replies: 4
    Last Post: 11-12-2014, 11:22 AM
  5. Return Highest & Lowest Value from Vlookup
    By ioswoody in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-13-2013, 01:05 AM
  6. [SOLVED] Arranging in order highest to lowest
    By neiluk121 in forum Excel General
    Replies: 7
    Last Post: 06-09-2012, 02:37 PM
  7. Replies: 6
    Last Post: 01-11-2012, 12:06 PM

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