A bit more detail...

I have a column with text entries, ie:

a
a
b
c
c
c
a
a
c

I'm looking for someway to display all the text entries, i.e. a,b,c, but
will also give how many times they appeared in the list, so it would look
something like
a 4
b 1
c 3

There may be several types of text in the column (i.e. a,b,c,d,e,f,g etc...)
so I'm looking for something where you don't have to type in the values.

There may also be empty cells in the list. I wouldn't want to count them.

Any ideas?



"andy" wrote:

how can I list items in a column with totals?

I have a column containing a list of multiple (text) items.

I'd like to have a summary, so that I have a list of the items together with
the totals of how many times the item appeared.

I guess this must be simple, but don't know how to go about it.

Cheers