I have a spreadsheet like this:

```
|     A     |    B   |        C        |
+-----------+--------+-----------------+
| Date      | Place  | Names           |
+-----------+--------+-----------------+
| 1/2/2013  | Place1 | John, Jane, Bob |
| 2/5/2013  | Place2 | Jane, Doug      |
| 3/8/2013  | Place3 | John, Jane      |
| 4/15/2013 | Place4 | Doug, Mark, Bob |

```

I want, in another sheet, to count the number of times a name (or word, basically) appears in column C on Sheet1, but the list needs to be dynamic. I could easily do a `=COUNTIF(Sheet1!C:C, "*John*")` to return 2, but then I have to do that for every person who appears in column C. So I first need to obtain a list of unique names in column C, split by comma, then do a count on each of those names and print them out alphabetically to look like this:

```
|     A     |   B   |
+-----------+-------+
| Name      | Count |
+-----------+-------+
| Bob       |   2   |
| Doug      |   2   |
| Jane      |   3   |
| John      |   2   |
| Mark      |   1   |

```