Forum Discussion
Multiple Criteria to pull multiple values in Excel Summary Table
DESCRIPTION: Hi, I need some help to read number and output to a summary table with multiple criterion. Tab 1: Raw data with information Tab 2: Example of dummy data. Basically, need to read text fr...
Hi,
That could be Pivot Table as attached
Thank you Sergei. Yes, pivot tables are quick to do on this but we want to have a formula extract those values on the multiple criteria. This will be used in addition to other columns we are extracting data from to have a summarized table for non-technical users who are not proficient at using pivot tables.