hello community, I'm looking to extract values from a spreadsheet based on multiple data. I used the following tutorial, which led me to create an array that worked perfectly for creating outputs based on 1 condition, but my attempts to expand it for 2 criterion haven't worked:
https://www.extendoffice.com/documents/excel/3381-excel-extract-unique-values-with-criteria.html
this is the original formula from the tutorial:
=INDEX($B$2:$B$17, MATCH(0, IF($D$2=$A$2:$A$17, COUNTIF($E$1:$E1, $B$2:$B$17), ""), 0))
I'd like to add something that says: and also make sure the extract is above an X threshold.
Thank you!
https://www.extendoffice.com/documents/excel/3381-excel-extract-unique-values-with-criteria.html
this is the original formula from the tutorial:
=INDEX($B$2:$B$17, MATCH(0, IF($D$2=$A$2:$A$17, COUNTIF($E$1:$E1, $B$2:$B$17), ""), 0))
I'd like to add something that says: and also make sure the extract is above an X threshold.
Thank you!
Last edited: