Google Sheets Help

[bgibbz]

So I am working on a little project involving a google form. Essentially, what i want to do is have google sheets somehow search for word repetitions in a given column . For example, if 15 people were to submit the name "bgibbz" into a text box in the form, i want somewhere on the spreadsheet to output 15. Is this possible? i noticed the script editor, and i could pretty easily code a script to do this if it was javascript, but im not sure what the programming language is or how to use the API. Any help would be appreciated, thanks!

[FurdTurgeson]

Just now, bgibbz said:

So I am working on a little project involving a google form. Essentially, what i want to do is have google sheets somehow search for word repetitions in a given column . For example, if 15 people were to submit the name "bgibbz" into a text box in the form, i want somewhere on the spreadsheet to output 15. Is this possible? i noticed the script editor, and i could pretty easily code a script to do this if it was javascript, but im not sure what the programming language is or how to use the API. Any help would be appreciated, thanks!

You can hit Crtl+F and type in "bgibbz" and jot down 15.

[bgibbz]

1 minute ago, WSADKeysGaming said:

You can hit Crtl+F and type in "bgibbz" and jot down 15.

obviously, but i am looking for an automated way due to the application.

[LogicalDrm]

Took bit Googling but I think I found it. Its

=COUNTIF(range;"value")

Where range is column, row or both. Like "C2:C50". And value with " " the text your are looking for. Note that it has to be exact. Capitalization doesn't matter. But mistypes will do.

[bgibbz]

5 hours ago, LoGiCalDrm said:

Took bit Googling but I think I found it. Its

=COUNTIF(range;"value")

Where range is column, row or both. Like "C2:C50". And value with " " the text your are looking for. Note that it has to be exact. Capitalization doesn't matter. But mistypes will do.

Thanks!