vba selecting entire range from offset

[gtd526]

Hello,
I use the following code to offset from A3:A23 to 3 columns over to D3:D23.
how can i select all from the offset ie A3:D23?
thanks

Range("A3:A27").SpecialCells(xlFormulas, xlNumbers).Select
Selection.Offset(0, 3).Select

NBA.xlsm
	A	B	C	D
2	Rank	Criteria2	Criteria2 Percentage	Count
3	1	Rank2, AL & AM >60%	80.0%	25
4	2	MOV2, AL:AM >= 60%	64.3%	28
5	3	Q, R, S, T>0, W	61.5%	13
6	4	MOV2 > ATS	59.5%	37
7	5	MOV2,MOV,AL:AM >= 60%	58.8%	34
8	5	MOV, AL:AM >= 60%	58.8%	34
9	7	K,L,Q,R>0,S>0,T>0	58.3%	12
10	8	Orange - Q,S,V,X,AA	57.1%	28
11	8	Rank2, AL >= 60%	57.1%	42
12	10	M,N>0, Q,R>0	55.6%	54
13	11	Asst/Tover >=1.85	55.2%	58
14	12	Q>=60%, S>=6	54.1%	37
15	13	Green - Q,S	53.7%	67
16	13	Aqua - L,Q,S	53.7%	67
17	15	Purple - Q,S,X	53.3%	45
18	16	K,L,Q,R>0,S>0,T>0,AC	50.0%	6
19	17	Cover2% > 60%	48.8%	41
20	18	K,L,Q,R>0,X	48.0%	25
21	19	Navy	47.8%	23
22	19	MOV2, MOV > ATS	47.8%	23
23	21	K,L,Q,R>0,X,AC	39.3%	28
24	#VALUE!	Pts in Paint (U:U)		0
25	#N/A	#N/A	#N/A	1
26	#N/A	#N/A	#N/A	Higher
27	#VALUE!	#VALUE!	#VALUE!	1
Sheet1

Cell Formulas
Range	Formula
C3:C27	C3	=IF($B3="Navy",Favs!$M$43,IF($B3="MOV2, MOV > ATS",Favs!$M$55,IF($B3="Purple - Q,S,X",Favs!$V$43,IF($B3="Green - Q,S",Favs!$P$43,IF($B3="Aqua - L,Q,S",Favs!$S$43,IF($B3="Orange - Q,S,V,X,AA",Favs!$Y$43,IF($B3="K,L,Q,R>0,S>0,T>0,AC",Favs!$AB$43,IF($B3="Rank2, AL & AM >60%",Favs!$AH$43,IF($B3="MOV, AL:AM >= 60%",Favs!$AB$67,IF($B3="MOV2, AL:AM >= 60%",Favs!$AE$67,IF($B3="MOV2,MOV,AL:AM >= 60%",Favs!$AH$67,IF($B3="K,L,Q,R>0,S>0,T>0",Favs!$P$67,IF($B3="K,L,Q,R>0,X",Favs!$M$67,IF($B3="K,L,Q,R>0,S>0,T>0,AC",Favs!$AB$43,IF($B3="K,L,Q,R>0,X,AC",Favs!$S$55,IF($B3="M,N>0, Q,R>0",Favs!$Y$79,IF($B3="Q>=60%, S>=6",Favs!$S$67,IF($B3="Q, R, S, T>0, W",Favs!$M$79,IF($B3="EPR (AH)",Favs!$M$91,IF($B3="MOV2 > ATS",Favs!$P$55,IF($B3="Adj OFF & DEF (AI, AJ)",Favs!$P$91,IF($B3="Asst/Tover >=1.85",Favs!$S$79,IF($B3="Poss/G (AD)",Favs!$S$91,IF($B3="K, R>0, T>0",Favs!$V$79,IF($B3="Tovers (AE)",Favs!$V$91,IF($B3="Steals (AF)",Favs!$Y$91,IF($B3="Rank2, AL >= 60%",Favs!$AB$55,IF($B3="Fouls (AG)",Favs!$AB$91,IF($B3="Cover2% > 60%",Favs!$AE$43,IF($B3="Rank2, AM >= 60%",Favs!$AE$55,IF($B3="Adj Off. (AI)",Favs!$AE$91,IF($B3="AC, AL & AM>= 60%",Favs!$AH$55,IF($B3="Adj Def. (AJ)",Favs!$AH$91,IF($B3="Pts in Paint (U:U)",Favs!$V$55,""))))))))))))))))))))))))))))))))))
D3	D3	=Favs!$AH$48
D4	D4	=Favs!$AE$72
D5	D5	=Favs!$M$84
D6	D6	=Favs!$P$60
D7	D7	=Favs!$AH$72
D8	D8	=Favs!$AB$72
D9	D9	=Favs!$P$72
D10	D10	=Favs!$Y$48
D11	D11	=Favs!$AB$60
D12	D12	=Favs!$Y$84
D13	D13	=Favs!$S$84
D14	D14	=Favs!$S$72
D15	D15	=Favs!$P$48
D16	D16	=Favs!$S$48
D17	D17	=Favs!$V$48
D18	D18	=Favs!$AB$48
D19	D19	=Favs!$AE$48
D20	D20	=Favs!$M$72
D21	D21	=Favs!$M$48
D22	D22	=Favs!$M$60
D23	D23	=Favs!$S$60
D24	D24	=Favs!$V$60
B25:B27	B25	=MID($A25,FIND("""",$A25)+1,FIND("""",$A25,FIND("""",$A25)+1)-FIND("""",$A25)-1)
D25	D25	=Favs!$AH$76
D26	D26	=Favs!$AH$77
D27	D27	=Favs!$AH$78
A3:A26	A3	=RANK(C3,Rank)

 

[Tetra201]

Try

Range("A3:A27").SpecialCells(xlFormulas, xlNumbers).Resize(, 4).Select

 

[gtd526]

Try

Range("A3:A27").SpecialCells(xlFormulas, xlNumbers).Resize(, 4).Select

Works great. Thank you. Now I have Resize on the brain.
If I have inserted columns in A&B, is there a way to select A3:F23 using the same method as above?

NBA.xlsm
	A	B	C	D	E	F
2	As FAV	As FAV	Rank	Criteria2	Criteria2 Percentage	Count
3	IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"Rank2, AL & AM >60%"	IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"Rank2, AL & AM >60%"	1	Rank2, AL & AM >60%	80.0%	25
4	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$S4>=$S5,ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"MOV2, AL:AM >= 60%"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$S4<=$S5,ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"MOV2, AL:AM >= 60%"	2	MOV2, AL:AM >= 60%	64.3%	28
5	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),ISNUMBER($T4),($T4>0),$W4>=$W5),"Q, R, S, T>0, W"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),ISNUMBER($T5),($T5>0),$W4<=$W5),"Q, R, S, T>0, W"	3	Q, R, S, T>0, W	61.5%	13
6	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),ISNUMBER($T4),($T4>0)),"MOV2 > ATS"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),ISNUMBER($T5),($T5>0)),"MOV2 > ATS"	4	MOV2 > ATS	59.5%	37
7	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$O4>=$O5,$S4>=$S5,ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"MOV2,MOV,AL:AM >= 60%"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$O4<=$O5,$S4<=$S5,ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"MOV2,MOV,AL:AM >= 60%"	5	MOV2,MOV,AL:AM >= 60%	58.8%	34
8	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$O4>=$O5,ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"MOV, AL:AM >= 60%"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$O4<=$O5,ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"MOV, AL:AM >= 60%"	5	MOV, AL:AM >= 60%	58.8%	34
9	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$K4<=$K5,$L4>=$L5,$Q4>=$Q5,ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),ISNUMBER($T4),($T4>0)),"K,L,Q,R>0,S>0,T>0"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$K4>=$K5,$L4>=$L5,$Q4>=$Q5,ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),ISNUMBER($T5),($T5>0)),"K,L,Q,R>0,S>0,T>0"	7	K,L,Q,R>0,S>0,T>0	58.3%	12
10	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$Q4>=$Q5,$S4>=$S5,$V4>=$V5,$X4>=$X5,$AA4>=$AA5),"Orange - Q,S,V,X,AA"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$Q4<=$Q5,$S4<=$S5,$V4<=$V5,$X4<=$X5,$AA4<=$AA5),"Orange - Q,S,V,X,AA"	8	Orange - Q,S,V,X,AA	57.1%	28
11	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),ISNUMBER($AL4),($AL4>=.6)),"Rank2, AL >= 60%"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),ISNUMBER($AL5),($AL5>=.6)),"Rank2, AL >= 60%"	8	Rank2, AL >= 60%	57.1%	42
12	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$M4>=$M5,ISNUMBER($N4),($N4>0),$Q4>=$Q5,ISNUMBER($R4),($R4>0)),"M,N>0, Q,R>0"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$M4<=$M5,ISNUMBER($N5),($N5>0),$Q4<=$Q5,ISNUMBER($R5),($R5>0)),"M,N>0, Q,R>0"	10	M,N>0, Q,R>0	55.6%	54
13	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$Y4>=$Y5),"Asst/Tover >=1.85"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$Y4<=$Y5),"Asst/Tover >=1.85"	11	Asst/Tover >=1.85	55.2%	58
14	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),ISNUMBER($Q4),($Q4>=0.6),ISNUMBER($S4),($S4>=6)),"Q>=60%, S>=6"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),ISNUMBER($Q5),($Q5>=0.6),ISNUMBER($S5),($S5>=6)),"Q>=60%, S>=6"	12	Q>=60%, S>=6	54.1%	37
15	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$Q4>=$Q5,$S4>=$S5),"Green - Q,S"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$Q4<=$Q5,$S4<=$S5),"Green - Q,S"	13	Green - Q,S	53.7%	67
16	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$L4>=$L5,$Q4>=$Q5,$S4>=$S5),"Aqua - L,Q,S"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$L4<=$L5,$Q4<=$Q5,$S4<=$S5),"Aqua - L,Q,S"	13	Aqua - L,Q,S	53.7%	67
17	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$Q4>=$Q5,$S4>=$S5,$X4>=$X5),"Purple - Q,S,X"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$Q4<=$Q5,$S4<=$S5,$X4<=$X5),"Purple - Q,S,X"	15	Purple - Q,S,X	53.3%	45
18	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$K4<=$K5,$L4>=$L5,$Q4>=$Q5,ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),ISNUMBER($T4),($T4>0),$AC4>=$AC5),"K,L,Q,R>0,S>0,T>0,AC"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$K4>=$K5,$L4<=$L5,$Q4<=$Q5,ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),ISNUMBER($T5),($T5>0),$AC4<=$AC5),"K,L,Q,R>0,S>0,T>0,AC"	16	K,L,Q,R>0,S>0,T>0,AC	50.0%	6
19	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),ISNUMBER($Q4),($Q4>=0.6)),"Cover2% > 60%"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),ISNUMBER($Q5),($Q5>=0.6)),"Cover2% > 60%"	17	Cover2% > 60%	48.8%	41
20	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$K4<=$K5,$L4>=$L5,$Q4>=$Q5,ISNUMBER($R4),($R4>0),$X4>=$X5),"K,L,Q,R>0,X"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$K4>=$K5,$L4>=$L5,$Q4<=$Q5,ISNUMBER($R4),($R4>0),$X4<=$X5),"K,L,Q,R>0,X"	18	K,L,Q,R>0,X	48.0%	25
21	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$N4>0,$P4>0,$R4>0,$T4>0),"Navy"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$N5>0,$P5>0,$R5>0,$T5>0),"Navy"	19	Navy	47.8%	23
22	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$P4>0,$T4>0),"MOV2, MOV > ATS"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$P5>0,$T5>0),"MOV2, MOV > ATS"	19	MOV2, MOV > ATS	47.8%	23
23	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$L4>=$L5,$X4>=$X5,$AC4>=$AC5),"K,L,Q,R>0,X,AC"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$L4<=$L5,$X4<=$X5,$AC4<=$AC5),"K,L,Q,R>0,X,AC"	21	K,L,Q,R>0,X,AC	39.3%	28
24	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$AI4>=$AI5),"Pts in Paint (U:U)"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$AI4<=$AI5),"Pts in Paint (U:U)"	#VALUE!	Pts in Paint (U:U)		0
25	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0))),"Misc"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0))),"Misc"	#VALUE!	Misc		1
26	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0))),"Misc"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0))),"Misc"	#VALUE!	Misc		Higher
27	,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),$S4>=$S5,$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0))),"Misc"	,IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),$S4<=$S5,$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0))),"Misc"	#VALUE!	Misc		1
Indicators

Cell Formulas
Range	Formula
D3:D27	D3	=MID($A3,FIND("""",$A3)+1,FIND("""",$A3,FIND("""",$A3)+1)-FIND("""",$A3)-1)
E3:E27	E3	=IF($D3="Navy",Favs!$M$43,IF($D3="MOV2, MOV > ATS",Favs!$M$55,IF($D3="Purple - Q,S,X",Favs!$V$43,IF($D3="Green - Q,S",Favs!$P$43,IF($D3="Aqua - L,Q,S",Favs!$S$43,IF($D3="Orange - Q,S,V,X,AA",Favs!$Y$43,IF($D3="K,L,Q,R>0,S>0,T>0,AC",Favs!$AB$43,IF($D3="Rank2, AL & AM >60%",Favs!$AH$43,IF($D3="MOV, AL:AM >= 60%",Favs!$AB$67,IF($D3="MOV2, AL:AM >= 60%",Favs!$AE$67,IF($D3="MOV2,MOV,AL:AM >= 60%",Favs!$AH$67,IF($D3="K,L,Q,R>0,S>0,T>0",Favs!$P$67,IF($D3="K,L,Q,R>0,X",Favs!$M$67,IF($D3="K,L,Q,R>0,S>0,T>0,AC",Favs!$AB$43,IF($D3="K,L,Q,R>0,X,AC",Favs!$S$55,IF($D3="M,N>0, Q,R>0",Favs!$Y$79,IF($D3="Q>=60%, S>=6",Favs!$S$67,IF($D3="Q, R, S, T>0, W",Favs!$M$79,IF($D3="EPR (AH)",Favs!$M$91,IF($D3="MOV2 > ATS",Favs!$P$55,IF($D3="Adj OFF & DEF (AI, AJ)",Favs!$P$91,IF($D3="Asst/Tover >=1.85",Favs!$S$79,IF($D3="Poss/G (AD)",Favs!$S$91,IF($D3="K, R>0, T>0",Favs!$V$79,IF($D3="Tovers (AE)",Favs!$V$91,IF($D3="Steals (AF)",Favs!$Y$91,IF($D3="Rank2, AL >= 60%",Favs!$AB$55,IF($D3="Fouls (AG)",Favs!$AB$91,IF($D3="Cover2% > 60%",Favs!$AE$43,IF($D3="Rank2, AM >= 60%",Favs!$AE$55,IF($D3="Adj Off. (AI)",Favs!$AE$91,IF($D3="AC, AL & AM>= 60%",Favs!$AH$55,IF($D3="Adj Def. (AJ)",Favs!$AH$91,IF($D3="Pts in Paint (U:U)",Favs!$V$55,""))))))))))))))))))))))))))))))))))
F3	F3	=Favs!$AH$48
F4	F4	=Favs!$AE$72
F5	F5	=Favs!$M$84
F6	F6	=Favs!$P$60
F7	F7	=Favs!$AH$72
F8	F8	=Favs!$AB$72
F9	F9	=Favs!$P$72
F10	F10	=Favs!$Y$48
F11	F11	=Favs!$AB$60
F12	F12	=Favs!$Y$84
F13	F13	=Favs!$S$84
F14	F14	=Favs!$S$72
F15	F15	=Favs!$P$48
F16	F16	=Favs!$S$48
F17	F17	=Favs!$V$48
F18	F18	=Favs!$AB$48
F19	F19	=Favs!$AE$48
F20	F20	=Favs!$M$72
F21	F21	=Favs!$M$48
F22	F22	=Favs!$M$60
F23	F23	=Favs!$S$60
F24	F24	=Favs!$V$60
F25	F25	=Favs!$AH$76
F26	F26	=Favs!$AH$77
F27	F27	=Favs!$AH$78
C3:C26	C3	=RANK(E3,Rank)

 

[Tetra201]

Try

Range("C3:C27").SpecialCells(xlFormulas, xlNumbers).Offset(, -2).Resize(, 6).Select

 

[gtd526]

Try

Range("C3:C27").SpecialCells(xlFormulas, xlNumbers).Offset(, -2).Resize(, 6).Select

Works perfect. I readjusted the Offset to -4 since im using E3:E27.
Thank you.

 

[Tetra201]

Glad to have helped.