Excel Question

[NakaNaka]

At work I'm compiling a list. It looks something like this.


A
A
A
A
B
B
C
D
E
F
F

Obviously much longer and not with letters. I want to turn that into a list for one of each letter and for it to say how often each comes up.

A 4
B 2
C 1
D 1
D 1
F 2

You get the idea. I can use either Excel or Access. Thanks

-Phil

P.S. - I posted something similar once but it was more complicated. This is less complex so maybe the answer will be more simple.

 

[akenbennu]

Countif(A:A,"A")
Countif(A:A,"B")
etc

(A:A) is whatever range of cells you have.

The text is the quotes is whatever value/text you want to count.

 

[NakaNaka]

Originally posted by: akenbennu
Countif(A:A,"A")
Countif(A:A,"B")
etc

(A:A) is whatever range of cells you have.

The text is the quotes is whatever value/text you want to count.

That's good, but I have thousands and thousands of things I need to count, and I don't want to manually change the formula each time to enter the correct word into "A" "B" "etc."

 

[Thyme]

Use a pivot table

 

[akenbennu]

You can also use the advanced filter, copy the row to another row, check the unique records box and that should give you a row of records with only nonduplicate entries. Then run the countif statement referencing that row. (I think the pivot tabel will probably work better for what you want.)