I am looking to add something like a FREQUENCY criteria to this
I have my index categories in Col B, and my LARGE in Col M, Col E is just a Month - if its equal to a Month number. I would like to add a FREQUENCY criteria to my index categories (Col B). i.e. if the category/text occurs 4 times then do the index-match-large.
FREQUENCY or COUNTIF(s)
Code:
=IFERROR(INDEX($B$2:$B$5000,MATCH(SUMPRODUCT(LARGE(($E$2:$E$5000=1)*($M$2:$M$5000),ROWS($A$1:A1))),IF(($E$2:$E$5000=1),$M$2:$M$5000),0)),"")
I have my index categories in Col B, and my LARGE in Col M, Col E is just a Month - if its equal to a Month number. I would like to add a FREQUENCY criteria to my index categories (Col B). i.e. if the category/text occurs 4 times then do the index-match-large.
FREQUENCY or COUNTIF(s)