Array formula to return multiple people that meet multiple criteria

[Schubby10]

Hi I really need some help with this. Sorry I can’t post the excel file here as it has private information.

What I am trying to do is get all of the names of people that spend over 1,000/ month that work for a specific company.

The names are in column a that need to be returned. The amount is column T and the company is column aq. All other info I do not need for this array query. Does anyone know how to write a formula for this ?

Thank you so much,

 

[Schubby10]

Thanks for all the help still doesn’t work. I appreciate all your help truly amazing.

 

[AhoyNC]

When I copied in your formula I got an error, however when I retyped "advertising" it worked???

I assume want to start entering data on ROW 24 based on your formula. If so, copy this formula into your spreadsheet.
Then press F2 for edit and then CTRL-SHIFT-ENTER to put in the formula. Then drag (not copy) the formula down the row.

[TABLE="width: 1250"]
<colgroup><col width="1250"></colgroup><tbody>[TR]
   [TD="width: 1250"]=IFERROR(INDEX(data!$A$2:$A$20000,SMALL(IF(data!$AQ$2:$AQ$20000="advertising",IF(data!$T$2:$T$20000>1000,ROW(data!$A$2:$A$20000)-ROW(data!$A$2)+1)),ROWS($A$24:A24))),"")[/TD]
 [/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Does this diagnostic change help?

Control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX(data!$A$2:$A$20000,SMALL(IF(TRIM(data!$AQ$2:$AQ$20000)="advertising",IF(ISNUMBER(ata!$T$2:$T$20000),IF(data!$T$2:$T$20000>1000,ROW(data!$A$2:$A$20000)-ROW(data!$A$2)+1))),ROWS($1:1))),"")

 

[Schubby10]

It worked thank you thank you thank you