I have a pretty good formula to select data based on one criteria. I would like to add a second criteria to my list.
{=INDEX($I:$I,SMALL(IF($L:$L=$B$2,ROW(I:I)+0),ROW(I1)))}
I use this formula to reference $B$2 which limits my results. I want to add another criteria and use $B$2 and $C$2 to limit results.
Please see attached.
Array Formula Multiple Criteria.xlsx
Bookmarks