In Excel what is equivalent function of table function in R

Question

For example I have a cell:

A
B
B
A
C

I want to have a summary of total count of each character:

A 2
B 2
C 1

How can I do this in Excel?

Answer 1

Insert > PivotTable

Select your column as the row field and as the value field. Change the value field calculation from sum to count if it defaults to sum.