+ Reply to Thread
Results 1 to 6 of 6

'Top 3' from master list

  1. #1
    Registered User
    Join Date
    09-10-2010
    Location
    UK, Bristol
    MS-Off Ver
    Excel 2007
    Posts
    30

    'Top 3' from master list

    I am looking to have a master list with following columns:
    index (#) | issues (text) | resolution (text) | severity (#) | status (open/closed)

    This is all manually entered.

    On another sheet I then want the top 3 of these (defined using a combination of 'highest severity' and 'open' displayed like this:

    1 | Issue
    | Resolution
    2 | Issue
    | Resolution
    3 | Issue
    | Resolution

    I've tried using Match to get the reference but I would appreciate some pointers as I need to complete it today and had another load of work just pile on top!

    Any help much appreciated

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,978

    Re: 'Top 3' from master list

    If you are looking for a speedy response, it would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Pete

  3. #3
    Registered User
    Join Date
    09-10-2010
    Location
    UK, Bristol
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: 'Top 3' from master list

    Thanks, please see attached.

    I've manually populated it to what I would like it to look like with the highest severity risk at #1 and so on, but only showing 'open' risks.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-10-2010
    Location
    UK, Bristol
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: 'Top 3' from master list

    I have got the top 3 open severities using LARGE on a product of
    =IF(STATUS='open',1,0) * severity

    This gives me the top 3 open severities, but as there may well be duplicate severity values, I can't then use this to VLOOKUP back to the descriptions.

  5. #5
    Registered User
    Join Date
    09-10-2010
    Location
    UK, Bristol
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: 'Top 3' from master list

    http://forum.chandoo.org/threads/fin...-solved.10675/

    This is the closest I can get to a solution - I would rather something a little more elegant!

  6. #6
    Registered User
    Join Date
    09-10-2010
    Location
    UK, Bristol
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: 'Top 3' from master list

    http://forum.chandoo.org/threads/fin...-solved.10675/

    This is the closest I can get to a solution - I would rather something a little more elegant!

+ 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. Creating a dynamic dropdown list of a selection of a master list
    By RooMar in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 05-15-2015, 05:27 AM
  2. A simple Macros to delete large bounced email list from master list?
    By Silverfawn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2015, 10:51 AM
  3. I'm trying to create a list of errors from raw data based on a master list
    By aperring in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2014, 10:47 AM
  4. [SOLVED] Filter values based on a master list and an input list
    By PY_ in forum Excel General
    Replies: 8
    Last Post: 04-12-2013, 06:36 AM
  5. Copy/Paste Cells from old list to new master list by matching values
    By rfsmith in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2012, 05:32 PM
  6. [SOLVED] Creating a grocery list in a new worksheet based on selected items in a master list
    By jacolli4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2012, 07:53 AM
  7. master list, input list - copy non matches to next free row
    By Jorus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2010, 07:53 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