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.