Jack-P-Winner
Member
I am not sure who helped me with this in the past. I think Narayan (-:
I am wanting to count the Es and Os vertically. Making the Es Green and Os red. The formulas used to count the numbers in WXYZ and placing the results in V are as follows:
=SUMPRODUCT((AU718:AX718<>1)*(AU717:AX717=1),AU718:AX718)
=IF(W717=W718,AU718+1,1)
=IF(X717=X718,AV718+1,1)
=IF(Y717=Y718,AW718+1,1)
=IF(Z717=Z718,AX718+1,1)
=ISODD(IFERROR(INDEX($W717:$Z717,MATCH($V717,$AU717:$AX717,0)),1))
I need formulas for IQ2:IU3001 with the exception of counting letters instead of numbers. I appreciate any help.
Thanks
I also have this on Microsoft site
http://answers.microsoft.com/en-us/...rtically/7e2bdfdd-3e99-4194-9551-4c00a21e683d
I am wanting to count the Es and Os vertically. Making the Es Green and Os red. The formulas used to count the numbers in WXYZ and placing the results in V are as follows:
=SUMPRODUCT((AU718:AX718<>1)*(AU717:AX717=1),AU718:AX718)
=IF(W717=W718,AU718+1,1)
=IF(X717=X718,AV718+1,1)
=IF(Y717=Y718,AW718+1,1)
=IF(Z717=Z718,AX718+1,1)
=ISODD(IFERROR(INDEX($W717:$Z717,MATCH($V717,$AU717:$AX717,0)),1))
I need formulas for IQ2:IU3001 with the exception of counting letters instead of numbers. I appreciate any help.
Thanks
I also have this on Microsoft site
http://answers.microsoft.com/en-us/...rtically/7e2bdfdd-3e99-4194-9551-4c00a21e683d
