Multiple Criteria to pull multiple values in Excel Summary Table

[dsb3465]

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"). Also attached.
https://drive.google.com/file/d/1n41c553oQGM9V0LCMzUciDfuE-fphNs8/view?usp=sharing

Any help would be greatly appreciated.

Thank you!

I also tried this youtube video but its very hard to follow array formula.
<

 

[dsb3465]

I am uploading a new file example1.xlsx. The old file had a typo in the name. Use this. Thanks

 

[pecoflyer]

Multiple cross posts without links ... (at least three)

 

[bosco_yip]

Please read the forum rule regarding : " Please Don't Cross Posting"

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.

• If you do cross-post, please put the website link in your post.

• Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

Regards
Bosco