Looking for a function to count alpha values in a range.

O

osmosys

Hey,

I'm looking for the right function that will look through a range and
tell me how many times it sees a particular non-numerical value.

For instance say I have these names in a column:

John
Ted
Andrew
John


The function would go through and count all the values for me and give
me this:


Total John: 2
Total Ted: 1
Total Andrew: 1

This would make it so I don't have to count each instance by myself.

Can excel do this?

Thanks

-osmosys
 
C

CLR

="John "&COUNTIF(A:A,"John")&CHAR(10)&"Ted
"&COUNTIF(A:A,"Ted")&CHAR(10)&"Andrew "&COUNTIF(A:A,"Andrew")

Format the cell for WarpText

Vaya con Dios,
Chuck, CABGx3
 
Top