Index, Match, Small with multiple criteria

[anhlu]

Hi everyone,
I need help with finding a combined function to list all the names that fit the criterias below:

Data:

Column A Column B Column C
Name Level Days
A P 1313
B H 144
C M 60
D P 773
E P 90
F P 60


Need to find all the names in Column A that fit both criterias: Level in column B is "P" and Days in Column C is larger than 145.

[Glenn Kennedy]

This is an Excel forum. Instead of posting a pdf... can you post an Excel file? thanks!

[FlameRetired]

Here are two different ways you can do it.

1.) Use a "helper" column in column D with this formula

Please Login or Register  to view this content.

Then enter this formula in A13, fill down and across until you get blanks.

Please Login or Register  to view this content.

2.) Or if you prefer to not use a helper column array enter this formula, fill down and across until you get blanks. 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.

Please Login or Register  to view this content.