Running Count is Slow in Google Sheets-CodePudding

Home > front end > Running Count is Slow in Google Sheets

Running Count is Slow in Google Sheets

Time：11-11

Here's my way of calculating running count by groups in Sheets:

=LAMBDA(a,INDEX(if(a="",,COUNTIFS(a,a,row(a),"<="&row(a)))))(B4:B)

The complexity of this formula is R^2 = 1000000 operations for 1K rows. I'd love to make more efficient formula, and tried combinations of LABMDA and SCAN. For now I've found only the way to do it fast with 1 group at a time:

=INDEX(IF(B4:B="


          
          
            Page link：https//www.codepudding.com/frontend/605972.html
          
          
               Prev:Is there a function that prevents a integer to be bigger or smaller than values (range)?
               Next:Extract date and numbers in google sheet from steam price history


  
    
      
        
          
             Tags：  
google-sheetsgoogle-sheets-formulaarray-formulas               
        
      
    
  
 
    
      
        
        	
            	Related
            
                       
        
      
    
  

  
    
      
        
           Links：  
          CodePudding

            
      
    
  


  About Us:          Contact Us      Terms of Service      
Privacy Policy
  Copyright © 2010-2023，Powered By CodePudding