Hi...I need help on how to accomplish this problem. The array formula
SUM(IF(FREQUENCY(IF(D14:D26 >= 90,MATCH(C14:C26,C14:C26,0)),ROW(C14:C26)-ROW(C15)+1),1)) only works for 1 condition but for multiple conditions like if the Training Index is <=89.99 and >=80, it doesn't work.
In my second problem, I may need to count the total unique teachers based on Quarters and the Training index conditions.
Appreciate any help.
Thanks.
SUM(IF(FREQUENCY(IF(D14:D26 >= 90,MATCH(C14:C26,C14:C26,0)),ROW(C14:C26)-ROW(C15)+1),1)) only works for 1 condition but for multiple conditions like if the Training Index is <=89.99 and >=80, it doesn't work.
In my second problem, I may need to count the total unique teachers based on Quarters and the Training index conditions.
Appreciate any help.
Thanks.
Last edited: