I have a worksheet with formulas in rows C, F, J, M, Q, and T. These formulas are lookups to another sheet so the result may look like this:
<tbody>
</tbody>
The actual formula looks like this if anyone cares:
The point is, just doing a regular countif, isn't going to work as the cells contain formulas.
I want to count all unique values in columns C, F, J, M, Q, and T. So if the value exists in C4 and T20, only count it once.
Thanks!
TT BRAVO QUICKY |
<tbody>
</tbody>
The actual formula looks like this if anyone cares:
Code:
=IF(ROW($A1)>COUNTIFS('Offensive Plays'!$F$2:$F$73,$H$26,'Offensive Plays'!$AF$2:$AF$73,"RT",'Offensive Plays'!$K$2:$K$73,"Yes"),"",INDEX('Offensive Plays'!C$2:C$73,MATCH(LARGE(INDEX(('Offensive Plays'!$F$2:$F$73=$H$26)*('Offensive Plays'!$K$2:$K$73="Yes")*('Offensive Plays'!$AF$2:$AF$73="RT")*(COUNTIF('Offensive Plays'!$C$2:$C$73,">="&'Offensive Plays'!$C$2:$C$73)),0),ROW($A1)),INDEX(('Offensive Plays'!$F$2:$F$73=$H$26)*(COUNTIF('Offensive Plays'!$C$2:$C$73,">="&'Offensive Plays'!$C$2:$C$73)),0),0)))
The point is, just doing a regular countif, isn't going to work as the cells contain formulas.
I want to count all unique values in columns C, F, J, M, Q, and T. So if the value exists in C4 and T20, only count it once.
Thanks!