Figured it out! =arrayformula(if(isblank(C2:C),"",(countif(C2:C,C2:C))))
On Friday, February 5, 2016 at 11:46:44 PM UTC-8, Randy Fairfield wrote: > > I'm using the following formula to count the number of times a string > appears in a column and it's working perfectly: > > =(countif(C2:C,C2)) > > However, instead of copying this formula into every row, I'd like to have > the formula automatically expand into cells below based on the number of > rows. For example, if there are fifty rows, I'd like the column with these > formulas to look as follows: > > =(countif(C3:C,C3)) > =(countif(C4:C,C4)) > ... > =(countif(C50:C,C50)) > > *What I don't want to have to do is manually have to go and add the > formula into the cells myself.* The number of rows are going to > constantly be changing when someone inputs form data using Google Forms. > Any help is appreciated! Something along the lines of IF there is data in, > say, any cell in the row below, THEN the formula should expand into the > cell in the row below as well. Does that make sense? > > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
