With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.

Sort spreadsheet rows into different sheets?

Hi all, I'm trying to sort a spreadsheet into different categories, and I would like it so that if a cell in a row contains one thing, it displays the row in another sheet, ie if the cell contains 'BH' then I would like it to be displayed in the sheet/page Bath (BH) which is visible at the bottom, or if it contains WS then to Wells (WS). I hope I've made that clear as it's quite hard to explain, I've attached a screenshot to show what I mean. I'm not sure if this is even possible but any help you can offer is much appreciated!

P.S. The screenshot is from the Sheets app on iPad, but I mostly use a Mac with Safari or Firefox, just to avoid any confusion!

---

Hi all, I'm trying to sort a spreadsheet into different categories, and I would like it so that if a cell in a row contains one thing, it displays the row in another sheet, ie if the cell contains 'BH' then I would like it to be displayed in the sheet/page Bath (BH) which is visible at the bottom, or if it contains WS then to Wells (WS). I hope I've made that clear as it's quite hard to explain, I've attached a screenshot to show what I mean. I'm not sure if this is even possible but any help you can offer is much appreciated!

P.S. The screenshot is from the Sheets app on iPad, but I mostly use a Mac with Safari or Firefox, just to avoid any confusion

I have a column with whole sentences in each cell. What I need is to count the frequency of each word in the column, and to display the results in a new column (in descending order of frequency).
An example is:
(row 1) The apple fell from the tree.
(row 2) The dog chased after the cat.
(row 3) The cat ran up the tree.
The formula would show (in a new column):
The - 6
Cat - 2
Tree -2
Chased - 1
...
Etc.
Preferably there would be a way to include a list of stopwords (so that 'the, or, if', etc, were not included in the count). I would provide the stopwords, perhaps in a separate column within the spreadsheet.
I am stumped - I have looked up and down the net for a solution, without luck.

I set up a reading log minutes data collection for the students in my class. The format is simple, I have their names on column A and then I add their time read on column, B, C, etc.

Ideally, I would like to set up google sheets so each week when I include their weekly minutes the sheet document automatically calculates the sums in each rows for each student. My goal is to be open the document and see one student's yearly sum immediately. I'd also like to avoid each having to go to "insert - function - sum" thousands of time during a school year.