Rank across Columns with no duplicates

[kckliodna]

This is just a small portion of my spreadsheet, it's fairly large, so I did a Snip-IT.
There are 23 cells that I want ranked 1-23, with any duplicate values ranking with different numbers, so there are no 2 #3s or "3.5" or 3 #6s as my snipit shows. For this example, cells EH14, EO14, EV14, FC14 - I need the Rank to value where it doesn't do duplicates. So EH14 should be 4, EO14 should be 5, EV14 should be 6, and FC14 should be 7. The cells to rank are the values under "TA" which are EN13, EU13, FB13, and FI13. If you need the other "3.5" cells, they are EA14 and EG13.
I have tried these formulas to no avail. For some reason, the beginning of the spreadsheet I did the first formula and it worked fine, but when I started adding more people, all the people at the end started showing the .5 or duplicate numbers. Can't figure that out either but if I can get the right formula, hopefully that won't matter.
Thanks in advance for any help/direction you can give me.
=RANK.AVG(EN13,(K$13,R$13,Y$13,AF$13,AM$13,AT$13,BA$13,BH$13,BO$13,BV$13,CC$13,CJ$13,CQ$13,CX$13,DE$13,DL$13,DS$13,DZ$13,EG$13,EN$13,EU$13,FB$13,FI$13))

=RANK.AVG(EN13,(K$13,R$13,Y$13,AF$13,AM$13,AT$13,BA$13,BH$13,BO$13,BV$13,CC$13,CJ$13,CQ$13,CX$13,DE$13,DL$13,DS$13,DZ$13,EG$13,EN$13,EU$13,FB$13,FI$13))+COUNTIF($$EN$13:EN13,EN13)-1

=RANK.EQ(EU13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIF($EU$13:EU13,EU13)-1

 

[Fluff]

Try it like

=RANK.EQ(K13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIFS($K$13:K13,K13,$K$12:K12,"TA")-1

 

[kckliodna]

Try it like

=RANK.EQ(K13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIFS($K$13:K13,K13,$K$12:K12,"TA")-1

Unfortunately that did not work either. Thanks for trying.

 

[Fluff]

Unfortunately that did not work either

In what way?

 

[kckliodna]

In what way?

It still produces the duplicates in ranking and skips numbers.

 

[kckliodna]

OT 8-14 mrexcel.xlsx
	EA	EB	EC	ED	EE	EF	EG	EH	EI	EJ	EK	EL	EM	EN	EO	EP	EQ	ER	ES	ET	EU	EV	EW	EX	EY	EZ	FA	FB	FC	FD	FE	FF	FG	FH	FI
12	Rte	LIST	NS DAY	TO	TOTW	TU	TA	Rte	LIST	NS DAY	TO	TOTW	TU	TA	Rte	LIST	NS DAY	TO	TOTW	TU	TA	Rte	LIST	NS DAY	TO	TOTW	TU	TA	Rte	LIST	NS DAY	TO	TOTW	TU	TA
13	95	WA	Brown	33	70.17	0.00	70.17	T6-1	NL	Yellow	33	70.17	0.00	70.17	T6-2	10	Black	32	64.17	0.00	64.17	T6-3	WA	Green	32	64.17	0.00	64.17	T6-4	NL	Black	32	64.17	0.00	64.17
14	3.00	Geno						3.00	Bill						8	Janice						8	Relijah						8	Jackie
15	SDO	OT W	U	Key	O	DT	TA	SDO	OT W	U	Key	O	DT	TA	SDO	OT W	U	Key	O	DT	TA	SDO	OT W	U	Key	O	DT	TA	SDO	OT W	U	Key	O	DT	TA
Quarter

Cell Formulas
Range	Formula
EB13	EB13	=IF(EA13=Schedule!B3,Schedule!D3,IF(EA13=Schedule!B4,Schedule!D4,IF(EA13=Schedule!B5,Schedule!D5,IF(EA13=Schedule!B6,Schedule!D6,IF(EA13=Schedule!B7,Schedule!D7,IF(EA13=Schedule!B8,Schedule!D8,IF(EA13=Schedule!B9,Schedule!D9,IF(EA13=Schedule!B10,Schedule!D10,IF(EA13=Schedule!B11,Schedule!D11,IF(EA13=Schedule!B12,Schedule!D12,IF(EA13=Schedule!B13,Schedule!D13,IF(EA13=Schedule!B14,Schedule!D14,IF(EA13=Schedule!B15,Schedule!D15,IF(EA13=Schedule!B16,Schedule!D16,IF(EA13=Schedule!B17,Schedule!D17,IF(EA13=Schedule!B18,Schedule!D18,IF(EA13=Schedule!B19,Schedule!D19,IF(EA13=Schedule!B20,Schedule!D20,IF(EA13=Schedule!B21,Schedule!D21,IF(EA13=Schedule!B22,Schedule!D22,IF(EA13=Schedule!B23,Schedule!D23,IF(EA13=Schedule!B24,Schedule!D24,IF(EA13=Schedule!B25,Schedule!D25,IF(EA13=Schedule!B26,Schedule!D26))))))))))))))))))))))))
EC13	EC13	=IF(EA13=Schedule!B3,Schedule!A3,IF(EA13=Schedule!B4,Schedule!A4,IF(EA13=Schedule!B5,Schedule!A5,IF(EA13=Schedule!B6,Schedule!A6,IF(EA13=Schedule!B7,Schedule!A7,IF(EA13=Schedule!B8,Schedule!A8,IF(EA13=Schedule!B9,Schedule!A9,IF(EA13=Schedule!B10,Schedule!A10,IF(EA13=Schedule!B11,Schedule!A11,IF(EA13=Schedule!B12,Schedule!A12,IF(EA13=Schedule!B13,Schedule!A13,IF(EA13=Schedule!B14,Schedule!A14,IF(EA13=Schedule!B15,Schedule!A15,IF(EA13=Schedule!B16,Schedule!A16,IF(EA13=Schedule!B17,Schedule!A17,IF(EA13=Schedule!B18,Schedule!A18,IF(EA13=Schedule!B19,Schedule!A19,IF(EA13=Schedule!B20,Schedule!A20,IF(EA13=Schedule!B21,Schedule!A21,IF(EA13=Schedule!B22,Schedule!A22,IF(EA13=Schedule!B23,Schedule!A23,IF(EA13=Schedule!B24,Schedule!A24,IF(EA13=Schedule!B25,Schedule!A25,IF(EA13=Schedule!B26,Schedule!A26))))))))))))))))))))))))
ED13,FF13,EY13,ER13,EK13	ED13	=SUMIF(EE16:EE113,"<>")
EE13,FG13,EZ13,ES13,EL13	EE13	=SUMIF(EA16:EB113,"<>")
EF13,FH13,FA13,ET13,EM13	EF13	=SUMIF(EC16:EC113,"<>")
EG13,FI13,FB13,EU13,EN13	EG13	=EG113
EI13	EI13	=IF(EH13=Schedule!B3,Schedule!D3,IF(EH13=Schedule!B4,Schedule!D4,IF(EH13=Schedule!B5,Schedule!D5,IF(EH13=Schedule!B6,Schedule!D6,IF(EH13=Schedule!B7,Schedule!D7,IF(EH13=Schedule!B8,Schedule!D8,IF(EH13=Schedule!B9,Schedule!D9,IF(EH13=Schedule!B10,Schedule!D10,IF(EH13=Schedule!B11,Schedule!D11,IF(EH13=Schedule!B12,Schedule!D12,IF(EH13=Schedule!B13,Schedule!D13,IF(EH13=Schedule!B14,Schedule!D14,IF(EH13=Schedule!B15,Schedule!D15,IF(EH13=Schedule!B16,Schedule!D16,IF(EH13=Schedule!B17,Schedule!D17,IF(EH13=Schedule!B18,Schedule!D18,IF(EH13=Schedule!B19,Schedule!D19,IF(EH13=Schedule!B20,Schedule!D20,IF(EH13=Schedule!B21,Schedule!D21,IF(EH13=Schedule!B22,Schedule!D22,IF(EH13=Schedule!B23,Schedule!D23,IF(EH13=Schedule!B24,Schedule!D24,IF(EH13=Schedule!B25,Schedule!D25,IF(EH13=Schedule!B26,Schedule!D26))))))))))))))))))))))))
EJ13	EJ13	=IF(EH13=Schedule!B3,Schedule!A3,IF(EH13=Schedule!B4,Schedule!A4,IF(EH13=Schedule!B5,Schedule!A5,IF(EH13=Schedule!B6,Schedule!A6,IF(EH13=Schedule!B7,Schedule!A7,IF(EH13=Schedule!B8,Schedule!A8,IF(EH13=Schedule!B9,Schedule!A9,IF(EH13=Schedule!B10,Schedule!A10,IF(EH13=Schedule!B11,Schedule!A11,IF(EH13=Schedule!B12,Schedule!A12,IF(EH13=Schedule!B13,Schedule!A13,IF(EH13=Schedule!B14,Schedule!A14,IF(EH13=Schedule!B15,Schedule!A15,IF(EH13=Schedule!B16,Schedule!A16,IF(EH13=Schedule!B17,Schedule!A17,IF(EH13=Schedule!B18,Schedule!A18,IF(EH13=Schedule!B19,Schedule!A19,IF(EH13=Schedule!B20,Schedule!A20,IF(EH13=Schedule!B21,Schedule!A21,IF(EH13=Schedule!B22,Schedule!A22,IF(EH13=Schedule!B23,Schedule!A23,IF(EH13=Schedule!B24,Schedule!A24,IF(EH13=Schedule!B25,Schedule!A25,IF(EH13=Schedule!B26,Schedule!A26))))))))))))))))))))))))
EP13	EP13	=IF(EO13=Schedule!B3,Schedule!D3,IF(EO13=Schedule!B4,Schedule!D4,IF(EO13=Schedule!B5,Schedule!D5,IF(EO13=Schedule!B6,Schedule!D6,IF(EO13=Schedule!B7,Schedule!D7,IF(EO13=Schedule!B8,Schedule!D8,IF(EO13=Schedule!B9,Schedule!D9,IF(EO13=Schedule!B10,Schedule!D10,IF(EO13=Schedule!B11,Schedule!D11,IF(EO13=Schedule!B12,Schedule!D12,IF(EO13=Schedule!B13,Schedule!D13,IF(EO13=Schedule!B14,Schedule!D14,IF(EO13=Schedule!B15,Schedule!D15,IF(EO13=Schedule!B16,Schedule!D16,IF(EO13=Schedule!B17,Schedule!D17,IF(EO13=Schedule!B18,Schedule!D18,IF(EO13=Schedule!B19,Schedule!D19,IF(EO13=Schedule!B20,Schedule!D20,IF(EO13=Schedule!B21,Schedule!D21,IF(EO13=Schedule!B22,Schedule!D22,IF(EO13=Schedule!B23,Schedule!D23,IF(EO13=Schedule!B24,Schedule!D24,IF(EO13=Schedule!B25,Schedule!D25,IF(EO13=Schedule!B26,Schedule!D26))))))))))))))))))))))))
EQ13	EQ13	=IF(EO13=Schedule!B3,Schedule!A3,IF(EO13=Schedule!B4,Schedule!A4,IF(EO13=Schedule!B5,Schedule!A5,IF(EO13=Schedule!B6,Schedule!A6,IF(EO13=Schedule!B7,Schedule!A7,IF(EO13=Schedule!B8,Schedule!A8,IF(EO13=Schedule!B9,Schedule!A9,IF(EO13=Schedule!B10,Schedule!A10,IF(EO13=Schedule!B11,Schedule!A11,IF(EO13=Schedule!B12,Schedule!A12,IF(EO13=Schedule!B13,Schedule!A13,IF(EO13=Schedule!B14,Schedule!A14,IF(EO13=Schedule!B15,Schedule!A15,IF(EO13=Schedule!B16,Schedule!A16,IF(EO13=Schedule!B17,Schedule!A17,IF(EO13=Schedule!B18,Schedule!A18,IF(EO13=Schedule!B19,Schedule!A19,IF(EO13=Schedule!B20,Schedule!A20,IF(EO13=Schedule!B21,Schedule!A21,IF(EO13=Schedule!B22,Schedule!A22,IF(EO13=Schedule!B23,Schedule!A23,IF(EO13=Schedule!B24,Schedule!A24,IF(EO13=Schedule!B25,Schedule!A25,IF(EO13=Schedule!B26,Schedule!A26))))))))))))))))))))))))
EW13	EW13	=IF(EV13=Schedule!B3,Schedule!D3,IF(EV13=Schedule!B4,Schedule!D4,IF(EV13=Schedule!B5,Schedule!D5,IF(EV13=Schedule!B6,Schedule!D6,IF(EV13=Schedule!B7,Schedule!D7,IF(EV13=Schedule!B8,Schedule!D8,IF(EV13=Schedule!B9,Schedule!D9,IF(EV13=Schedule!B10,Schedule!D10,IF(EV13=Schedule!B11,Schedule!D11,IF(EV13=Schedule!B12,Schedule!D12,IF(EV13=Schedule!B13,Schedule!D13,IF(EV13=Schedule!B14,Schedule!D14,IF(EV13=Schedule!B15,Schedule!D15,IF(EV13=Schedule!B16,Schedule!D16,IF(EV13=Schedule!B17,Schedule!D17,IF(EV13=Schedule!B18,Schedule!D18,IF(EV13=Schedule!B19,Schedule!D19,IF(EV13=Schedule!B20,Schedule!D20,IF(EV13=Schedule!B21,Schedule!D21,IF(EV13=Schedule!B22,Schedule!D22,IF(EV13=Schedule!B23,Schedule!D23,IF(EV13=Schedule!B24,Schedule!D24,IF(EV13=Schedule!B25,Schedule!D25,IF(EV13=Schedule!B26,Schedule!D26))))))))))))))))))))))))
EX13	EX13	=IF(EV13=Schedule!B3,Schedule!A3,IF(EV13=Schedule!B4,Schedule!A4,IF(EV13=Schedule!B5,Schedule!A5,IF(EV13=Schedule!B6,Schedule!A6,IF(EV13=Schedule!B7,Schedule!A7,IF(EV13=Schedule!B8,Schedule!A8,IF(EV13=Schedule!B9,Schedule!A9,IF(EV13=Schedule!B10,Schedule!A10,IF(EV13=Schedule!B11,Schedule!A11,IF(EV13=Schedule!B12,Schedule!A12,IF(EV13=Schedule!B13,Schedule!A13,IF(EV13=Schedule!B14,Schedule!A14,IF(EV13=Schedule!B15,Schedule!A15,IF(EV13=Schedule!B16,Schedule!A16,IF(EV13=Schedule!B17,Schedule!A17,IF(EV13=Schedule!B18,Schedule!A18,IF(EV13=Schedule!B19,Schedule!A19,IF(EV13=Schedule!B20,Schedule!A20,IF(EV13=Schedule!B21,Schedule!A21,IF(EV13=Schedule!B22,Schedule!A22,IF(EV13=Schedule!B23,Schedule!A23,IF(EV13=Schedule!B24,Schedule!A24,IF(EV13=Schedule!B25,Schedule!A25,IF(EV13=Schedule!B26,Schedule!A26))))))))))))))))))))))))
FD13	FD13	=IF(FC13=Schedule!B3,Schedule!D3,IF(FC13=Schedule!B4,Schedule!D4,IF(FC13=Schedule!B5,Schedule!D5,IF(FC13=Schedule!B6,Schedule!D6,IF(FC13=Schedule!B7,Schedule!D7,IF(FC13=Schedule!B8,Schedule!D8,IF(FC13=Schedule!B9,Schedule!D9,IF(FC13=Schedule!B10,Schedule!D10,IF(FC13=Schedule!B11,Schedule!D11,IF(FC13=Schedule!B12,Schedule!D12,IF(FC13=Schedule!B13,Schedule!D13,IF(FC13=Schedule!B14,Schedule!D14,IF(FC13=Schedule!B15,Schedule!D15,IF(FC13=Schedule!B16,Schedule!D16,IF(FC13=Schedule!B17,Schedule!D17,IF(FC13=Schedule!B18,Schedule!D18,IF(FC13=Schedule!B19,Schedule!D19,IF(FC13=Schedule!B20,Schedule!D20,IF(FC13=Schedule!B21,Schedule!D21,IF(FC13=Schedule!B22,Schedule!D22,IF(FC13=Schedule!B23,Schedule!D23,IF(FC13=Schedule!B24,Schedule!D24,IF(FC13=Schedule!B25,Schedule!D25,IF(FC13=Schedule!B26,Schedule!D26))))))))))))))))))))))))
FE13	FE13	=IF(FC13=Schedule!B3,Schedule!A3,IF(FC13=Schedule!B4,Schedule!A4,IF(FC13=Schedule!B5,Schedule!A5,IF(FC13=Schedule!B6,Schedule!A6,IF(FC13=Schedule!B7,Schedule!A7,IF(FC13=Schedule!B8,Schedule!A8,IF(FC13=Schedule!B9,Schedule!A9,IF(FC13=Schedule!B10,Schedule!A10,IF(FC13=Schedule!B11,Schedule!A11,IF(FC13=Schedule!B12,Schedule!A12,IF(FC13=Schedule!B13,Schedule!A13,IF(FC13=Schedule!B14,Schedule!A14,IF(FC13=Schedule!B15,Schedule!A15,IF(FC13=Schedule!B16,Schedule!A16,IF(FC13=Schedule!B17,Schedule!A17,IF(FC13=Schedule!B18,Schedule!A18,IF(FC13=Schedule!B19,Schedule!A19,IF(FC13=Schedule!B20,Schedule!A20,IF(FC13=Schedule!B21,Schedule!A21,IF(FC13=Schedule!B22,Schedule!A22,IF(FC13=Schedule!B23,Schedule!A23,IF(FC13=Schedule!B24,Schedule!A24,IF(FC13=Schedule!B25,Schedule!A25,IF(FC13=Schedule!B26,Schedule!A26))))))))))))))))))))))))
EA14	EA14	=RANK.EQ(EG13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIFS($EG$13:EG13,EG13,$EG$12:EG12,"TA")-1
EB14	EB14	=IF(EA13=Schedule!B3,Schedule!C3,IF(EA13=Schedule!B4,Schedule!C4,IF(EA13=Schedule!B5,Schedule!C5,IF(EA13=Schedule!B6,Schedule!C6,IF(EA13=Schedule!B7,Schedule!C7,IF(EA13=Schedule!B8,Schedule!C8,IF(EA13=Schedule!B9,Schedule!C9,IF(EA13=Schedule!B10,Schedule!C10,IF(EA13=Schedule!B11,Schedule!C11,IF(EA13=Schedule!B12,Schedule!C12,IF(EA13=Schedule!B13,Schedule!C13,IF(EA13=Schedule!B14,Schedule!C14,IF(EA13=Schedule!B15,Schedule!C15,IF(EA13=Schedule!B16,Schedule!C16,IF(EA13=Schedule!B17,Schedule!C17,IF(EA13=Schedule!B18,Schedule!C18,IF(EA13=Schedule!B19,Schedule!C19,IF(EA13=Schedule!B20,Schedule!C20,IF(EA13=Schedule!B21,Schedule!C21,IF(EA13=Schedule!B22,Schedule!C22,IF(EA13=Schedule!B23,Schedule!C23,IF(EA13=Schedule!B24,Schedule!C24,IF(EA13=Schedule!B25,Schedule!C25,IF(EA13=Schedule!B26,Schedule!C26))))))))))))))))))))))))
EH14	EH14	=RANK.EQ(EN13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIFS($EN$13:EN13,EN13,$EN$12:EN12,"TA")-1
EI14	EI14	=IF(EH13=Schedule!B3,Schedule!C3,IF(EH13=Schedule!B4,Schedule!C4,IF(EH13=Schedule!B5,Schedule!C5,IF(EH13=Schedule!B6,Schedule!C6,IF(EH13=Schedule!B7,Schedule!C7,IF(EH13=Schedule!B8,Schedule!C8,IF(EH13=Schedule!B9,Schedule!C9,IF(EH13=Schedule!B10,Schedule!C10,IF(EH13=Schedule!B11,Schedule!C11,IF(EH13=Schedule!B12,Schedule!C12,IF(EH13=Schedule!B13,Schedule!C13,IF(EH13=Schedule!B14,Schedule!C14,IF(EH13=Schedule!B15,Schedule!C15,IF(EH13=Schedule!B16,Schedule!C16,IF(EH13=Schedule!B17,Schedule!C17,IF(EH13=Schedule!B18,Schedule!C18,IF(EH13=Schedule!B19,Schedule!C19,IF(EH13=Schedule!B20,Schedule!C20,IF(EH13=Schedule!B21,Schedule!C21,IF(EH13=Schedule!B22,Schedule!C22,IF(EH13=Schedule!B23,Schedule!C23,IF(EH13=Schedule!B24,Schedule!C24,IF(EH13=Schedule!B25,Schedule!C25,IF(CEH3=Schedule!B26,Schedule!C26))))))))))))))))))))))))
EO14	EO14	=RANK.EQ(EU13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIFS($EU$13:EU13,EU13,$EU$12:EU12,"TA")-1
EP14	EP14	=IF(EO13=Schedule!B3,Schedule!C3,IF(EO13=Schedule!B4,Schedule!C4,IF(EO13=Schedule!B5,Schedule!C5,IF(EO13=Schedule!B6,Schedule!C6,IF(EO13=Schedule!B7,Schedule!C7,IF(EO13=Schedule!B8,Schedule!C8,IF(EO13=Schedule!B9,Schedule!C9,IF(EO13=Schedule!B10,Schedule!C10,IF(EO13=Schedule!B11,Schedule!C11,IF(EO13=Schedule!B12,Schedule!C12,IF(EO13=Schedule!B13,Schedule!C13,IF(EO13=Schedule!B14,Schedule!C14,IF(EO13=Schedule!B15,Schedule!C15,IF(EO13=Schedule!B16,Schedule!C16,IF(EO13=Schedule!B17,Schedule!C17,IF(EO13=Schedule!B18,Schedule!C18,IF(EO13=Schedule!B19,Schedule!C19,IF(EO13=Schedule!B20,Schedule!C20,IF(EO13=Schedule!B21,Schedule!C21,IF(EO13=Schedule!B22,Schedule!C22,IF(EO13=Schedule!B23,Schedule!C23,IF(EO13=Schedule!B24,Schedule!C24,IF(EO13=Schedule!B25,Schedule!C25,IF(EO13=Schedule!B26,Schedule!C26))))))))))))))))))))))))
EV14	EV14	=RANK.EQ(FB13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIFS($FB$13:FB13,FB13,$FB$12:FB12,"TA")-1
EW14	EW14	=IF(EV13=Schedule!B3,Schedule!C3,IF(EV13=Schedule!B4,Schedule!C4,IF(EV13=Schedule!B5,Schedule!C5,IF(EV13=Schedule!B6,Schedule!C6,IF(EV13=Schedule!B7,Schedule!C7,IF(EV13=Schedule!B8,Schedule!C8,IF(EV13=Schedule!B9,Schedule!C9,IF(EV13=Schedule!B10,Schedule!C10,IF(EV13=Schedule!B11,Schedule!C11,IF(EV13=Schedule!B12,Schedule!C12,IF(EV13=Schedule!B13,Schedule!C13,IF(EV13=Schedule!B14,Schedule!C14,IF(EV13=Schedule!B15,Schedule!C15,IF(EV13=Schedule!B16,Schedule!C16,IF(EV13=Schedule!B17,Schedule!C17,IF(EV13=Schedule!B18,Schedule!C18,IF(EV13=Schedule!B19,Schedule!C19,IF(EV13=Schedule!B20,Schedule!C20,IF(EV13=Schedule!B21,Schedule!C21,IF(EV13=Schedule!B22,Schedule!C22,IF(EV13=Schedule!B23,Schedule!C23,IF(EV13=Schedule!B24,Schedule!C24,IF(EV13=Schedule!B25,Schedule!C25,IF(EV13=Schedule!B26,Schedule!C26))))))))))))))))))))))))
FC14	FC14	=RANK.EQ(FI13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIFS($FI$13:FI13,FI13,$FI$12:FI12,"TA")-1
FD14	FD14	=IF(FC13=Schedule!B3,Schedule!C3,IF(FC13=Schedule!B4,Schedule!C4,IF(FC13=Schedule!B5,Schedule!C5,IF(FC13=Schedule!B6,Schedule!C6,IF(C13=Schedule!B7,Schedule!C7,IF(FC13=Schedule!B8,Schedule!C8,IF(FC13=Schedule!B9,Schedule!C9,IF(FC13=Schedule!B10,Schedule!C10,IF(FC13=Schedule!B11,Schedule!C11,IF(FC13=Schedule!B12,Schedule!C12,IF(FC13=Schedule!B13,Schedule!C13,IF(FC13=Schedule!B14,Schedule!C14,IF(FC13=Schedule!B15,Schedule!C15,IF(FC13=Schedule!B16,Schedule!C16,IF(FC13=Schedule!B17,Schedule!C17,IF(FC13=Schedule!B18,Schedule!C18,IF(FC13=Schedule!B19,Schedule!C19,IF(FC13=Schedule!B20,Schedule!C20,IF(FC13=Schedule!B21,Schedule!C21,IF(FC13=Schedule!B22,Schedule!C22,IF(FC13=Schedule!B23,Schedule!C23,IF(FC13=Schedule!B24,Schedule!C24,IF(FC13=Schedule!B25,Schedule!C25,IF(FC13=Schedule!B26,Schedule!C26))))))))))))))))))))))))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
FC14:FD14	Expression	=$FE$13="N/A"	text	NO
EW14:FB14	Expression	=$EX$13="N/A"	text	NO
EO14:EP14	Expression	=$EQ$13="N/A"	text	NO
FE13	Cell Value	contains "N/A"	text	NO
FC14:FD14	Expression	=$FE$13="Red"	text	NO
FC14:FD14	Expression	=$FE$13="Green"	text	NO
FC14:FD14	Expression	=$FE$13="Yellow"	text	NO
FC14:FD14	Expression	=$FE$13="Brown"	text	NO
FC14:FD14	Expression	=$FE$13="Blue"	text	NO
FC14:FD14	Expression	=$FE$13="Black"	text	NO
FE13	Cell Value	contains "GREEN"	text	YES
FE13	Cell Value	contains "BLUE"	text	YES
FE13	Cell Value	contains "YELLOW"	text	YES
FE13	Cell Value	contains "BLACK"	text	YES
FE13	Cell Value	contains "RED"	text	YES
FE13	Cell Value	contains "BROWN"	text	YES
FD13:FE13	Cell Value	contains "GREEN"	text	NO
FD13:FE13	Cell Value	contains "BLUE"	text	NO
FD13:FE13	Cell Value	contains "YELLOW"	text	NO
FD13:FE13	Cell Value	contains "BLACK"	text	NO
FD13:FE13	Cell Value	contains "RED"	text	NO
FD13:FE13	Cell Value	contains "BROWN"	text	NO
EX13	Cell Value	contains "N/A"	text	NO
EV14:EW14	Expression	=$EX$13="Red"	text	NO
EV14:EW14	Expression	=$EX$13="Green"	text	NO
EV14:EW14	Expression	=$EX$13="Yellow"	text	NO
EV14:EW14	Expression	=$EX$13="Brown"	text	NO
EV14:EW14	Expression	=$EX$13="Blue"	text	NO
EV14:EW14	Expression	=$EX$13="Black"	text	NO
EX13	Cell Value	contains "GREEN"	text	YES
EX13	Cell Value	contains "BLUE"	text	YES
EX13	Cell Value	contains "YELLOW"	text	YES
EX13	Cell Value	contains "BLACK"	text	YES
EX13	Cell Value	contains "RED"	text	YES
EX13	Cell Value	contains "BROWN"	text	YES
EW13:EX13	Cell Value	contains "GREEN"	text	NO
EW13:EX13	Cell Value	contains "BLUE"	text	NO
EW13:EX13	Cell Value	contains "YELLOW"	text	NO
EW13:EX13	Cell Value	contains "BLACK"	text	NO
EW13:EX13	Cell Value	contains "RED"	text	NO
EW13:EX13	Cell Value	contains "BROWN"	text	NO
EQ13	Cell Value	contains "N/A"	text	NO
EO14:EP14	Expression	=$EQ$13="Red"	text	NO
EO14:EP14	Expression	=$EQ$13="Green"	text	NO
EO14:EP14	Expression	=$EQ$13="Yellow"	text	NO
EO14:EP14	Expression	=$EQ$13="Brown"	text	NO
EO14:EP14	Expression	=$EQ$13="Blue"	text	NO
EO14:EP14	Expression	=$EQ$13="Black"	text	NO
EQ13	Cell Value	contains "GREEN"	text	YES
EQ13	Cell Value	contains "BLUE"	text	YES
EQ13	Cell Value	contains "YELLOW"	text	YES
EQ13	Cell Value	contains "BLACK"	text	YES
EQ13	Cell Value	contains "RED"	text	YES
EQ13	Cell Value	contains "BROWN"	text	YES
EP13:EQ13	Cell Value	contains "GREEN"	text	NO
EP13:EQ13	Cell Value	contains "BLUE"	text	NO
EP13:EQ13	Cell Value	contains "YELLOW"	text	NO
EP13:EQ13	Cell Value	contains "BLACK"	text	NO
EP13:EQ13	Cell Value	contains "RED"	text	NO
EP13:EQ13	Cell Value	contains "BROWN"	text	NO
EJ13	Cell Value	contains "N/A"	text	NO
EH14:EI14	Expression	=$EJ$13="Red"	text	NO
EH14:EI14	Expression	=$EJ$13="Green"	text	NO
EH14:EI14	Expression	=$EJ$13="Yellow"	text	NO
EH14:EI14	Expression	=$EJ$13="Brown"	text	NO
EH14:EI14	Expression	=$EJ$13="Blue"	text	NO
EH14:EI14	Expression	=$EJ$13="Black"	text	NO
EJ13	Cell Value	contains "GREEN"	text	YES
EJ13	Cell Value	contains "BLUE"	text	YES
EJ13	Cell Value	contains "YELLOW"	text	YES
EJ13	Cell Value	contains "BLACK"	text	YES
EJ13	Cell Value	contains "RED"	text	YES
EJ13	Cell Value	contains "BROWN"	text	YES
EI13:EJ13	Cell Value	contains "GREEN"	text	NO
EI13:EJ13	Cell Value	contains "BLUE"	text	NO
EI13:EJ13	Cell Value	contains "YELLOW"	text	NO
EI13:EJ13	Cell Value	contains "BLACK"	text	NO
EI13:EJ13	Cell Value	contains "RED"	text	NO
EI13:EJ13	Cell Value	contains "BROWN"	text	NO
EC13	Cell Value	contains "N/A"	text	NO
EA14:EB14	Expression	=$EC$13="RED"	text	NO
EA14:EB14	Expression	=$EC$13="GREEN"	text	NO
EA14:EB14	Expression	=$EC$13="YELLOW"	text	NO
EA14:EB14	Expression	=$EC$13="BROWN"	text	NO
EA14:EB14	Expression	=$EC$13="BLUE"	text	NO
EA14:EB14	Expression	=$EC13="BLACK"	text	NO
EC13	Cell Value	contains "GREEN"	text	YES
EC13	Cell Value	contains "BLUE"	text	YES
EC13	Cell Value	contains "YELLOW"	text	YES
EC13	Cell Value	contains "BLACK"	text	YES
EC13	Cell Value	contains "RED"	text	YES
EC13	Cell Value	contains "BROWN"	text	YES
EB13:EC13	Cell Value	contains "GREEN"	text	NO
EB13:EC13	Cell Value	contains "BLUE"	text	NO
EB13:EC13	Cell Value	contains "YELLOW"	text	NO
EB13:EC13	Cell Value	contains "BLACK"	text	NO
EB13:EC13	Cell Value	contains "RED"	text	NO
EB13:EC13	Cell Value	contains "BROWN"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
EA13	List	N/A,34,38,40,41,45,46,47,48,49,50,51,52,59,60,64,66,67,68,95,T6-1,T6-2,T6-3,T6-4
EH13	List	N/A,34,38,40,41,45,46,47,48,49,50,51,52,59,60,64,66,67,68,95,T6-1,T6-2,T6-3,T6-4
EO13	List	N/A,34,38,40,41,45,46,47,48,49,50,51,52,59,60,64,66,67,68,95,T6-1,T6-2,T6-3,T6-4
EV13	List	N/A,34,38,40,41,45,46,47,48,49,50,51,52,59,60,64,66,67,68,95,T6-1,T6-2,T6-3,T6-4
FC13	List	N/A,34,38,40,41,45,46,47,48,49,50,51,52,59,60,64,66,67,68,95,T6-1,T6-2,T6-3,T6-4

 

[Fluff]

The formula for EA14 should be

=RANK.EQ(EG13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIFS($K$13:EG13,EG13,$K$12:EG12,"TA")-1

and for EH14

=RANK.EQ(EN13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIFS($K$13:EN13,EN13,$K$12:EN12,"TA")-1

 

[kckliodna]

The formula for EA14 should be

=RANK.EQ(EG13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIFS($K$13:EG13,EG13,$K$12:EG12,"TA")-1

and for EH14

=RANK.EQ(EN13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIFS($K$13:EN13,EN13,$K$12:EN12,"TA")-1

Ah, I see what we did. We replaced all the 'K's in the COUNTIFS to the corresponding cell, thinking that's what it should be. We went back through and made the corrections and now it works perfectly.

THANK YOU!!

 

[Fluff]

You're welcome & thanks for the feedback.