+ Reply to Thread
Results 1 to 5 of 5

Two criteria, multiple results into a single cell

  1. #1
    Registered User
    Join Date
    12-30-2020
    Location
    San Jose, CA
    MS-Off Ver
    2016
    Posts
    2

    Two criteria, multiple results into a single cell

    Hi, everyone.

    So, first time using a forum for this kind of thing so be gentle!

    What I'm trying to do: Search a range of cells for two criteria and place the results into a single cell.

    Basically, pivot table functionality with fixed columns and rows.

    Attached is my sample.

    Sheet Data has my data.

    Sheet Results has what I want to show. The example of what I'm looking for is in cell D7 of the Results tab. The criteria to meet is row 1 and column 1 (A) and place into the correct cell.

    Thanks so much for any help!
    Attached Files Attached Files

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,877

    Re: Two criteria, multiple results into a single cell

    v A B C D E F
    3 Data Quarter
    4 Type Subtype Q1 Q2 Q3 Q4
    5 Anemone Green Bubble Tip Green Bubble Tip Order
    6 Rainbow Bubble Tip Rainbow Bubble Tip Order Rainbow Bubble Tip Order
    7 Rock Flower Rock Flower Order
    8 Coral Acan Acan Order Acan Order
    9 CandyCane CandyCane Order
    10 GSP GSP Order
    11 Xenia Xenia Order
    12 Zoa Zoa Order
    13 Fish Angel Angel Order
    14 Clown Clown Order
    15 Damsel Damsel Order
    16 Gramma Gramma Order
    17 Tang Tang Order Yellow Tang Order, Powder Blue Tang Order

    Using Power Pivot and creating a measure

    See the file attached. For directions look at this link. https://sfmagazine.com/post-entry/ju...a-pivot-table/
    Attached Files Attached Files
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,308

    Re: Two criteria, multiple results into a single cell

    Vba option...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sintek; 12-31-2020 at 03:08 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  4. #4
    Registered User
    Join Date
    12-30-2020
    Location
    San Jose, CA
    MS-Off Ver
    2016
    Posts
    2

    Re: Two criteria, multiple results into a single cell

    Thank you so much, sintek. That's perfect. Now to figure out what all that code means...

    I really do appreciate the help!!

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,308

    Re: Two criteria, multiple results into a single cell

    Glad I could contribute...tx for rep...

    Please Login or Register  to view this content.

+ 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] Filter multiple sheets based on 3 criteria and return results into single cell
    By matt2877 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-02-2021, 12:07 AM
  2. [SOLVED] Returning Multiple Results into a Single Cell
    By hmltnangel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2018, 09:18 AM
  3. Index Match w/single criteria, multiple results
    By Mflick in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-06-2018, 06:34 PM
  4. Replies: 16
    Last Post: 02-21-2017, 02:10 AM
  5. Multiple Search Criteria produces (list) Multiple results in a single cell
    By snake007uk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2014, 12:13 PM
  6. [SOLVED] lookup multiple values of a single cell and return sum of results
    By Zeppelin17 in forum Excel General
    Replies: 7
    Last Post: 08-10-2011, 07:09 PM
  7. [SOLVED] Displaying the results of multiple formulas in a single cell.
    By gallegos1580 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-12-2005, 01: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