+ Reply to Thread
Results 1 to 2 of 2

'Top 3' drawn from master list

  1. #1
    Registered User
    Join Date
    09-10-2010
    Location
    UK, Marlborough
    MS-Off Ver
    365 (latest beta)
    Posts
    57

    'Top 3' drawn 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
    24,819

    Re: 'Top 3' drawn from master list

    Duplicate thread - see one of your other threads.

    Pete

+ 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. combo box displays values from a list drawn from spreadsheet
    By lifeseeker1019 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2014, 01:26 AM
  4. 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
  5. [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
  6. 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
  7. [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

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