Which array formula will return matches based on several criteria?

[excelos]

Hello

I read that some formulas return all matches in an array e.g. {match1, match2, match3, etc}

My question is which formulas do that and which specifically accepts multiple AND/OR criteria?

Thanks!

 

[James006]

Hello,

Your question is very generic ... :wink:

All functions can be used into an Array Formula ...

Why don't you post a specific problem ...

 

[excelos]

Hello,

Your question is very generic ... :wink:

All functions can be used into an Array Formula ...

Why don't you post a specific problem ...

Sorry, I am not asking which "formulas can be used in into an array formula"

I am asking which array formulas return an array of matches based on multiple criteria with AND/OR conditions.

 

[James006]

You are welcome

https://www.mrexcel.com/forum/excel-questions/1091961-return-list-matches.html

 

[DanteAmor]

Review:

AND and OR are typically not used with array formulas because it will evaluate the AND and the OR across all the values of the array, not independently.

 

[James006]

Thread rebounded at ...

https://www.mrexcel.com/forum/excel...xtract-values-based-criteria.html#post5248688