**7**

votes

**3**answers

17k views

### How to Label / Tag Items in a Spreadsheet

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 ...

**7**

votes

**11**answers

20k views

### Can you convert an address to a zip code in a spreadsheet?

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 ...

**1**

vote

**1**answer

1k views

### Spreadsheet formula to count consecutive values in a column

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
...

**1**

vote

**4**answers

4k views

### excel / google spreadsheet: count substring occurrences within a cell

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 ...

**2**

votes

**1**answer

3k views

### Google Spreadsheets: Counting number of matches between two rows

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 ...

**0**

votes

**1**answer

84 views

### Run formula from different sheet

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)
...