Preacherman771
New Member
 Joined
 Jun 15, 2021
 Messages
 27
 Office Version

 365
 Platform

 Windows
I am trying to count the number of each group of duplicate values in column O25:O40 using COUNTIF($O$25:$O$40,"0.688"). Knowing that the values in that column are textual and not actual numeric values, how would I go about changing them to numeric as part of my formula. Or, do I need to first create a helper column? Any help is greatly appreciated.
NFL 20212022 Standings (Template).xlsx  

H  I  J  K  L  M  N  O  
23  
24  Rnd 1  Team  Team  Pct  
25  1  KC    
26  2  BUF    
27  3  PIT    
28    TBD  BAL  0.688  
29    TBD  CLE  0.688  
30    TBD  IND  0.688  
31    TBD  TEN  0.688  
32  8  MIA    
33  9  LV    
34    TBD  NE  0.438  
35    TBD  LAC  0.438  
36  12  DEN    
37  13  CIN    
38  14  HOU    
39  15  NYJ    
40  16  JAX    
Calc_Ties (Conf) 
Cell Formulas  

Range  Formula  
J25:J40  J25  =IFERROR(INDEX($H$7:$H$22,MATCH(K25,$I$7:$I$22,0)),"") 
K25:K40  K25  =IF(AND(K7=K8,OR(ROWS(K$25:K25)*COLUMNS(K$25:K25)=1,ROWS(K$25:K25)*COLUMNS(K$25:K25)=16)),"TBD", IF(OR(K6=K7,K7=K8),"TBD",I7)) 
M25:M40  M25  =IF(K25<>"TBD","",I7) 
O25:O40  O25  =IF(M25<>"",INDEX($K$7:$K$22,MATCH(M25,$I$7:$I$22,0)),"") 