+ Reply to Thread
Results 1 to 2 of 2

Create Unique List from Multiple Criteria

  1. #1
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Create Unique List from Multiple Criteria

    Hi everyone,

    I've searched the forums and google and haven't been able to find quite what I'm looking for. Here's the situation:

    Worksheet1: Analysis
    Worksheet2: Answer Data Month 1

    Analysis:

    Cells A3 and B3 contact the search identifier. I.e., A3&B3
    Cells E7:E30 are where the unique list will be outputted to

    Answer Data Month 1

    Column BA contains the list of search identifiers as listed above. I.e. A3&B3
    Column BC contains text “Correct” or “Wrong”
    Column BB contains all possible text returns

    Ask:

    Create a macro which will generate a unique list of all results from column Answer Data Month 1 BB based on a search of results from Analysis A3&B3 and Answer Data Month 1 BC with text “Wrong”.

    So effectively, when the macro is run, Cells E7:E30 in Analysis will be populated with every entry listed in column BB in Answer Data Month 1 based on the lookup value from A3&B3 in Analysis in column BA in Answer Data Month 1 and the word “Wrong” in column BB in Answer Data Month 1.

    Any ideas?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Create Unique List from Multiple Criteria

    Doesnt sound like you need a macro for this. Upload a sample workbook so we dont have to guess
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Create unique list of values from two ranges with criteria
    By ThirtyTwo in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 06-13-2014, 10:46 AM
  2. [SOLVED] Looking to create a list of unique names that match criteria without using an array
    By john dalton in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-28-2014, 04:28 AM
  3. [SOLVED] Create list based on criteria and is unique
    By joannelittell in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-13-2013, 02:33 PM
  4. [SOLVED] Create unique list based on specific criteria
    By Joynesy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-21-2013, 05:54 AM
  5. Create Unique List with Criteria
    By Fos605 in forum Excel General
    Replies: 2
    Last Post: 07-20-2010, 07:57 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