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.
![test.png](/board/proxy.php?image=http%3A%2F%2Fteachngx.com%2FNational_Geographic_Explorer%2FNGX%2520e-Resources%2FImages%2Ftest.png&hash=20f81b7d90d7a034869cfa8569f29561)
Last edited: