Extracting multiple strings from a table based on multiple criteria

**McKneezy** · 03-10-2020, 12:53 PM

Hello,

I am attempting to extract certain data based on a table.

Basically, there is an ID column listing IDs (contains duplicates) and I would like to extract cells based on a multiple reference criteria to create another table that will be simpler to compile the data I desire.

Please see the enclosed sample workbook with clear notes and detailed instruction.

Thanks to anyone who can help!

**FlameRetired** · 03-10-2020, 09:23 PM

Please find in the attached column I to return IDs. I just went ahead and returned the unique IDs with this array formula.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

Then the counts of those IDs within the criteria that are "Copilot" in column J.

Formula:

Please Login or Register  to view this content.

Then array entered in K2 filled down and across column N

Formula:

Please Login or Register  to view this content.

Extracting multiple strings from a table based on multiple criteria

LinkBack

Thread Tools

Rate This Thread

Display