Minifs function
Is there a function that will behave as a "Minifs" function? I need to cross reference a column on another sheet and return the minimum value based on a matching criteria.
Best Answer
-
You can combine COLLECT (to evaluate your matching criteria) with MIN to get your desired result.
=MIN(COLLECT({the range to collect and evaluate MIN}, {criterion range 1}, criterion1, {criterion range 2}, criterion2β¦))
See more about COLLECT here; there are examples of this application on the page:
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Answers
-
You can combine COLLECT (to evaluate your matching criteria) with MIN to get your desired result.
=MIN(COLLECT({the range to collect and evaluate MIN}, {criterion range 1}, criterion1, {criterion range 2}, criterion2β¦))
See more about COLLECT here; there are examples of this application on the page:
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Thank you, that worked. I had something with the collect out of order. Thanks again
Help Article Resources
Categories
Check out the Formula Handbook template!
