Contents of a column/table

Hi All,

I want to do something seemingly easy:

Suppose I have this data

Column

RowAa
RowAa
RowAa
RowAa
RowAa
RowAb
RowAb

And I want to get to this:

RowAa 5 (as it occurred 5 times)
RowAb 2 (idem, 2 times)

I could do countif(A1:A7, “=RowAa) (supposing the data is are located in A1:A7)

However, I don’t want to assign all countif’s manually to the values I want to count.

As a somewhat acceptable solution I tried:
countif(A1:A7, “=A1”) which mysteriously comes up with 0.

All I want to do is have an overview what’s in the table. That’s: what values and how often.

Anybody have a way of doing this?

Cheers,

Dennis

Hi Dennis

Use a Pivot Table to do this. If you haven't used them before here's a useful guide:

http://peltiertech.com/Excel/Pivots/pivottables.htm

Regarding your problem formula, that would need to be:

=COUNTIF(A1:A7,"=" & A1)

or more simply:

=COUNTIF(A1:A7,A1)

Richard