Multiple Criteria to pull multiple values in Excel Summary Table

dsb3465

New Member
Joined
Mar 11, 2019
Messages
2
DESCRIPTION:
Hi, I need some help to read number and output to a summary table with multiple criterion using an excel formula. It is easily done using pivot tables but my audience is not tech savvy and need a formula to extract the values from Tab1.

Tab 1: Raw data with information
Tab 2: Example of dummy data. Basically, need to read text from column C, D, E in Raw Data

Tab 1 based on 2 criterion (Pillar and Group - columns A, B in Tab 1) and then spit out results in Tab 2 - Desired output. Note that in some cases there is more than one date/value to extract out based on the criterion.


Criteria should be based on Column A and B (Group and Pillar) ....
and when the criteria meets, it may or may not have more than 1 value (for example: Group 1, Pillar 1 might have 2 dates/values in column C for example. so I have to pull both dates in my summary table.

Please see below the data and excel file ("example.xlsx").
https://drive.google.com/file/d/1n41c553oQGM9V0LCMzUciDfuE-fphNs8/view?usp=sharing



Thank you!
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,456
Office Version
  1. 365
Platform
  1. Windows
Cross-posted:
https://chandoo.org/forum/threads/m...multiple-values-in-excel-summary-table.41169/
and
https://www.excelguru.ca/forums/sho...lues-in-Excel-Summary-Table&p=40573#post40573

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,736
use PivotTable, Group and Pilar to Filter area, the rest to the Row area
 

Watch MrExcel Video

Forum statistics

Threads
1,108,911
Messages
5,525,593
Members
409,653
Latest member
rishir

This Week's Hot Topics

Top