Excel array formula with multiple criteria.

[Schubby10]

Hi all. Hoping someone can assist. I apologize I can not post excel file as info should not be shared. I am looking to return all the unique identifiers of all the people in a certain company who spend over a certain amount. This could be multiple people so I have unique identifier for each.
My unique identifiers are in column a, my spend is T and my companies are Aq.
Does anyone know the best way to go about his or have a sample formula.

Thanks

 

[Chihiro]

...I can not post excel file as info should not be shared.

Sure you can. Just desensitize the info, while keeping data structure same. Ex. Replace names with Name1, Name2 etc, values can be randomized etc...

Without sample, we'd be guessing as to what is actually stored in each cell/range.

 

[Schubby10]

There is a lot of info and I would prefer not for sake of my job. I am sorry

 

[Chihiro]

Then I am sorry, we can't help you.

 

[Schubby10]

Couldn’t even help me understand how to structure?

 

[Chihiro]

http://lmgtfy.com/?q=Excel+extract+unique+values+with+multiple+criteria

 

[Schubby10]

Wow alright

 

[Peter Bartholomew]

@Schubby10
Did you get a result for you problem?
The attached workbook goes through a potential solution step by step.
It is possible to formulate the solution using array formulas to remove the helper ranges but that may leave it looking too much like magic.