After having searched Google & Co. for hours and trying various examples, I still could not figure out out how to solve what I thought would be trivial to calculate in Excel:

Having a table with e.g.

```
Column 1
--------
A
A
B
A
C
D
D
E
```

I want to know how often the distinct values are present. E.g. on a second sheet something like:

```
Column 1 | Count
----------+-------
A | 3
B | 1
C | 1
D | 2
E | 1
```

**My question is:**

Is this possible at all to do with built-in Excel formulas?

If not, I would import it into an Access database and use some SQL to achieve the results, but I really would love to do it in Excel only.