I'm a novice at spreadsheets, so I hope you'll forgive me if I'm asking a super obvious question. Is it possible to use tags in Excel/Google Spreadsheet? I'm creating a spreadsheet to log all the ...
Given a column of street addresses with city and state but no zip in a spreadsheet, I'd like to put a formula in a second column that yields the ZIP code. Do you know a way to do this? I'm dealing ...
I have a column with "Y" and "N" values, and need a formula to count the last consecutive occurrences of "Y". So if I the column looks like this: Y Y Y N Y N Y Y the desired result would be 2 Y Y ...
I've been scratching my head trying to figure out a way to count the number of occurrences of a substring within a cell. For example: | | A | | 1 |John,John,Tom,David| What ...
In a spreadsheet in Google Spreadsheets, I have multiple-choice answers I would like to grade. One row (user 0) contains the answer key, and the other rows contain user answers. User Q1 Q2 Q3 ...
Can you run formulas from different sheets? (not simply showing the formula as a string/static text) Say I type =Sheet1!A1 where in that cell I have a formula =concatenate(ice&cream) ...