Counting number of times a value occurs
 

How can I calculate the number of times same name appears in list of 400 names?
Thank you

Counting number of times a value occurs
 

COUNTIF
--
David Biddulph

"da" wrote in message
...
How can I calculate the number of times same name appears in list of 400
names?
Thank you

Counting number of times a value occurs
 

Thanks, but I need to count how many times a name is repeated, not just the
total number of names. If "smith" appears 10 times in a list, I want the
result to show Smith-10.
Jones,-8
Adam-6, etc.

"David Biddulph" wrote:

COUNTIF
--
David Biddulph

"da" wrote in message
...
How can I calculate the number of times same name appears in list of 400
names?
Thank you

Counting number of times a value occurs
 

Yes, that's why I said COUNTIF, not COUNTA.
--
David Biddulph

"da" wrote in message
...
Thanks, but I need to count how many times a name is repeated, not just
the
total number of names. If "smith" appears 10 times in a list, I want the
result to show Smith-10.
Jones,-8
Adam-6, etc.

"David Biddulph" wrote:

COUNTIF
--
David Biddulph

"da" wrote in message
...
How can I calculate the number of times same name appears in list of
400
names?
Thank you

Counting number of times a value occurs
 

Assuming you have only the names column (Col A) then enter this in B1 and
copy down
=COUNTIF(A:A,A1)

Altenatively
enter 1 against each name in Col B.
Then create PIVOTTABLE using A:B as range
It will give you the count

Let me know how it goes....

"da" wrote:

How can I calculate the number of times same name appears in list of 400 names?
Thank you

Counting number of times a value occurs
 

Thanks, but I am not getting the result I want. I have listed the names
below. I want to count how many times each name appears in the list.

Name
MUCHIRI
VASQUEZ,O
ALBA
SMITH,SM
SHEPHERD
GARCIA,E
HOLLIDAY
DYE
FARNIA
HERNANDEZ,A
MUCHIRI
VASQUEZ,O
ROJAS
WILLIAMS,A
IRALDO
TA
STATEN
TUNG
KUO
CHEN
ALBA
SMITH,SM
SHEPHERD
GARCIA,E
DYE
FARNIA
K. OJEDA
MUCHIRI
VALDENOR
DENNISTON
ALBA
SMITH,SM
SHEPHERD
REHDER
OJEDA
LANE
KILAYKO
BEAN
JENKINS
CONEY
BAEZ
GATEWOOD
DYE
FARNIA
DICKSON
JONES, D
MOORE
VALDENOR
SCARBOROUGH
SMITH,SM
DRUMMOND
SHEPHERD
REHDER
LANE
JENKINS
CONEY
BAEZ
HOLLIDAY
WILLIAMS,E
ANGEL
SHIN,J
CO
VALDENOR
ANDREWS
SMITH,SM
SHEPHERD
SANTANA
JENKINS
CONEY
BAEZ
WILLIAMS,E
LEWIS,D
SHIN,J
IRALDO
KUO
ANDREWS
SMITH,SM
SHEPHERD
KILAYKO
ZAMBRANO
BEAN
JENKINS
CONEY
BAEZ
ANDRADE,R
LEWIS,D
WASHINGTON
VASQUEZ,O
ROJAS
WILLIAMS,A
DENNISTON
CRUZ,C
CHEN
SMITH,SM
SHEPHERD
GARCIA,E
KILAYKO
CONEY
GATEWOOD
DYE
MUCHIRI
VASQUEZ,O
DENNISTON
CRUZ,C
CHEN
ALBA
SMITH,SM
SHEPHERD
GARCIA,A
HOLLIDAY
DYE
FARNIA
HERNANDEZ,A
MUCHIRI
VASQUEZ,O
ROJAS
WILLIAMS,A
TA
STATEN
TUNG
KUO
DENNISTON
CHEN
ALBA
SMITH,SM
SHEPHERD
GARCIA,E
CONEY
DYE
FARNIA
VALDENOR
CRUZ,C
ALBA
SMITH,SM
SHEPHERD
LANE
KILAYKO
BEAN
JENKINS
CONEY
BAEZ
GATEWOOD
DYE
FARNIA
DICKSON
MOORE
VALDENOR
SCARBOROUGH
SMITH,SM
DRUMMOND
SHEPHERD
LANE
JENKINS
CONEY
BAEZ
HOLLIDAY
WILLIAMS,E
ANGEL
SHIN,J
CO
VALDENOR
IRALDO
ANDREWS
SMITH,SM
SHEPHERD
SANTANA
JENKINS
CONEY
WILLIAMS,E
LEWIS,D
SHIN,J
KUO
DENNISTON
ANDREWS
SMITH,SM
SHEPHERD
KILAYKO
BEAN
JENKINS
CONEY
GATEWOOD
ANDRADE,R
WILDS
LEWIS,D
WASHINGTON
HERNANDEZ,A
MUCHIRI
VASQUEZ,O
ROJAS
IRALDO
DENNISTON
CRUZ,C
CHEN
SMITH,SM
SHEPHERD
GARCIA,E
KILAYKO
CONEY
DYE
WILDS
MUCHIRI
VASQUEZ,O
DENNISTON
CRUZ,C
CHEN
ALBA
SMITH,SM
SHEPHERD
GARCIA,E
HOLLIDAY
DYE
FARNIA
MUCHIRI
VASQUEZ,O
ROJAS
WILLIAMS,A
IRALDO
TA
STATEN
TUNG
SCARBOROUGH
KUO
DENNISTON
CRUZ,C
CHEN
ALBA
SMITH,SM
SHEPHERD
GARCIA,E
CONEY
DYE
FARNIA
MUCHIRI
VALDENOR
ALBA
SMITH,SM
SHEPHERD
REHDER
LANE
KILAYKO
BEAN
JENKINS
CONEY
BAEZ
GATEWOOD
DYE
ANDRADE,R
FARNIA
K. OJEDA
DICKSON
JONES, D
MOORE
VALDENOR
SMITH,SM
DRUMMOND
SHEPHERD
REHDER
OJEDA
YANEZ
LANE
JENKINS
CONEY
BAEZ
HOLLIDAY
WILLIAMS,E
ANGEL
SHIN,J
CO
VALDENOR
ANDREWS
SMITH,SM
SHEPHERD
SANTANA
JENKINS
CONEY
BAEZ
WILLIAMS,E
LEWIS,D
SHIN,J
IRALDO
KUO
DENNISTON
ANDREWS
SMITH,SM
SHEPHERD
KILAYKO
ZAMBRANO
BEAN
JENKINS
CONEY
BAEZ
GATEWOOD
WILDS
LEWIS,D
WASHINGTON
HERNANDEZ,A
VASQUEZ,O
ROJAS
DENNISTON
CRUZ,C
CHEN
SMITH,SM
SHEPHERD
GARCIA,E
KILAYKO
CONEY
DYE
VASQUEZ,O
DENNISTON
CRUZ,C
CHEN
ALBA
SMITH,SM
SHEPHERD
GARCIA,E
CONEY
HOLLIDAY
DYE
FARNIA
VASQUEZ,O
ROJAS
WILLIAMS,A
TA
STATEN
TUNG
SCARBOROUGH
KUO
DENNISTON
CRUZ,C
CHEN
ALBA
SMITH,SM
SHEPHERD
GARCIA,E
CONEY
DYE
FARNIA
VALDENOR
ALBA
SMITH,SM
SHEPHERD
REHDER
LANE
KILAYKO
BEAN
JENKINS
CONEY
BAEZ
GATEWOOD
DYE
FARNIA
DICKSON
JONES, D
MOORE
VALDENOR
SMITH,SM
DRUMMOND
SHEPHERD
REHDER
LANE
JENKINS
CONEY
BAEZ
HOLLIDAY
WILLIAMS,E
ANGEL
SHIN,J
CO
VALDENOR
IRALDO
SMITH,SM
SHEPHERD
SANTANA
JENKINS
CONEY
BAEZ
LEWIS,D
SHIN,J
KUO
DENNISTON
ANDREWS
SMITH,SM
SHEPHERD
KILAYKO
BEAN
JENKINS
CONEY
BAEZ
GATEWOOD
WILDS
LEWIS,D
WASHINGTON
VASQUEZ,O
ROJAS
IRALDO
DENNISTON
CRUZ,C
CHEN
SMITH,SM
SHEPHERD
GARCIA,E
KILAYKO
DYE
WILDS


"Sheeloo" wrote:

Assuming you have only the names column (Col A) then enter this in B1 and
copy down
=COUNTIF(A:A,A1)

Altenatively
enter 1 against each name in Col B.
Then create PIVOTTABLE using A:B as range
It will give you the count

Let me know how it goes....

"da" wrote:

How can I calculate the number of times same name appears in list of 400 names?
Thank you

Counting number of times a value occurs
 

This is what I got using PIVOT TABLE;
Name Total
ALBA 12
ANDRADE,R 3
ANDREWS 7
ANGEL 4
BAEZ 14
BEAN 8
CHEN 11
CO 4
CONEY 23
CRUZ,C 10
DENNISTON 14
DICKSON 4
DRUMMOND 4
DYE 16
FARNIA 12
GARCIA,A 1
GARCIA,E 11
GATEWOOD 8
HERNANDEZ,A 4
HOLLIDAY 8
IRALDO 8
JENKINS 16
JONES, D 3
K. OJEDA 2
KILAYKO 12
KUO 8
LANE 8
LEWIS,D 8
MOORE 4
MUCHIRI 9
OJEDA 2
REHDER 6
ROJAS 8
SANTANA 4
SCARBOROUGH 4
SHEPHERD 28
SHIN,J 8
SMITH,SM 28
STATEN 4
TA 4
TUNG 4
VALDENOR 12
VASQUEZ,O 12
WASHINGTON 4
WILDS 4
WILDS 1
WILLIAMS,A 5
WILLIAMS,E 7
YANEZ 1
ZAMBRANO 2
Grand Total 404

and this is what I got using the formula I had given against your list;
MUCHIRI - 9
VASQUEZ,O - 12
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
GARCIA,E - 11
HOLLIDAY - 8
DYE - 16
FARNIA - 12
HERNANDEZ,A - 4
MUCHIRI - 9
VASQUEZ,O - 12
ROJAS - 8
WILLIAMS,A - 5
IRALDO - 8
TA - 4
STATEN - 4
TUNG - 4
KUO - 8
CHEN - 11
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
GARCIA,E - 11
DYE - 16
FARNIA - 12
K. OJEDA - 2
MUCHIRI - 9
VALDENOR - 12
DENNISTON - 14
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
REHDER - 6
OJEDA - 2
LANE - 8
KILAYKO - 12
BEAN - 8
JENKINS - 16
CONEY - 23
BAEZ - 14
GATEWOOD - 8
DYE - 16
FARNIA - 12
DICKSON - 4
JONES, D - 3
MOORE - 4
VALDENOR - 12
SCARBOROUGH - 4
SMITH,SM - 28
DRUMMOND - 4
SHEPHERD - 28
REHDER - 6
LANE - 8
JENKINS - 16
CONEY - 23
BAEZ - 14
HOLLIDAY - 8
WILLIAMS,E - 7
ANGEL - 4
SHIN,J - 8
CO - 4
VALDENOR - 12
ANDREWS - 7
SMITH,SM - 28
SHEPHERD - 28
SANTANA - 4
JENKINS - 16
CONEY - 23
BAEZ - 14
WILLIAMS,E - 7
LEWIS,D - 8
SHIN,J - 8
IRALDO - 8
KUO - 8
ANDREWS - 7
SMITH,SM - 28
SHEPHERD - 28
KILAYKO - 12
ZAMBRANO - 2
BEAN - 8
JENKINS - 16
CONEY - 23
BAEZ - 14
ANDRADE,R - 3
LEWIS,D - 8
WASHINGTON - 4
VASQUEZ,O - 12
ROJAS - 8
WILLIAMS,A - 5
DENNISTON - 14
CRUZ,C - 10
CHEN - 11
SMITH,SM - 28
SHEPHERD - 28
GARCIA,E - 11
KILAYKO - 12
CONEY - 23
GATEWOOD - 8
DYE - 16
MUCHIRI - 9
VASQUEZ,O - 12
DENNISTON - 14
CRUZ,C - 10
CHEN - 11
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
GARCIA,A - 1
HOLLIDAY - 8
DYE - 16
FARNIA - 12
HERNANDEZ,A - 4
MUCHIRI - 9
VASQUEZ,O - 12
ROJAS - 8
WILLIAMS,A - 5
TA - 4
STATEN - 4
TUNG - 4
KUO - 8
DENNISTON - 14
CHEN - 11
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
GARCIA,E - 11
CONEY - 23
DYE - 16
FARNIA - 12
VALDENOR - 12
CRUZ,C - 10
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
LANE - 8
KILAYKO - 12
BEAN - 8
JENKINS - 16
CONEY - 23
BAEZ - 14
GATEWOOD - 8
DYE - 16
FARNIA - 12
DICKSON - 4
MOORE - 4
VALDENOR - 12
SCARBOROUGH - 4
SMITH,SM - 28
DRUMMOND - 4
SHEPHERD - 28
LANE - 8
JENKINS - 16
CONEY - 23
BAEZ - 14
HOLLIDAY - 8
WILLIAMS,E - 7
ANGEL - 4
SHIN,J - 8
CO - 4
VALDENOR - 12
IRALDO - 8
ANDREWS - 7
SMITH,SM - 28
SHEPHERD - 28
SANTANA - 4
JENKINS - 16
CONEY - 23
WILLIAMS,E - 7
LEWIS,D - 8
SHIN,J - 8
KUO - 8
DENNISTON - 14
ANDREWS - 7
SMITH,SM - 28
SHEPHERD - 28
KILAYKO - 12
BEAN - 8
JENKINS - 16
CONEY - 23
GATEWOOD - 8
ANDRADE,R - 3
WILDS - 4
LEWIS,D - 8
WASHINGTON - 4
HERNANDEZ,A - 4
MUCHIRI - 9
VASQUEZ,O - 12
ROJAS - 8
IRALDO - 8
DENNISTON - 14
CRUZ,C - 10
CHEN - 11
SMITH,SM - 28
SHEPHERD - 28
GARCIA,E - 11
KILAYKO - 12
CONEY - 23
DYE - 16
WILDS - 4
MUCHIRI - 9
VASQUEZ,O - 12
DENNISTON - 14
CRUZ,C - 10
CHEN - 11
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
GARCIA,E - 11
HOLLIDAY - 8
DYE - 16
FARNIA - 12
MUCHIRI - 9
VASQUEZ,O - 12
ROJAS - 8
WILLIAMS,A - 5
IRALDO - 8
TA - 4
STATEN - 4
TUNG - 4
SCARBOROUGH - 4
KUO - 8
DENNISTON - 14
CRUZ,C - 10
CHEN - 11
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
GARCIA,E - 11
CONEY - 23
DYE - 16
FARNIA - 12
MUCHIRI - 9
VALDENOR - 12
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
REHDER - 6
LANE - 8
KILAYKO - 12
BEAN - 8
JENKINS - 16
CONEY - 23
BAEZ - 14
GATEWOOD - 8
DYE - 16
ANDRADE,R - 3
FARNIA - 12
K. OJEDA - 2
DICKSON - 4
JONES, D - 3
MOORE - 4
VALDENOR - 12
SMITH,SM - 28
DRUMMOND - 4
SHEPHERD - 28
REHDER - 6
OJEDA - 2
YANEZ - 1
LANE - 8
JENKINS - 16
CONEY - 23
BAEZ - 14
HOLLIDAY - 8
WILLIAMS,E - 7
ANGEL - 4
SHIN,J - 8
CO - 4
VALDENOR - 12
ANDREWS - 7
SMITH,SM - 28
SHEPHERD - 28
SANTANA - 4
JENKINS - 16
CONEY - 23
BAEZ - 14
WILLIAMS,E - 7
LEWIS,D - 8
SHIN,J - 8
IRALDO - 8
KUO - 8
DENNISTON - 14
ANDREWS - 7
SMITH,SM - 28
SHEPHERD - 28
KILAYKO - 12
ZAMBRANO - 2
BEAN - 8
JENKINS - 16
CONEY - 23
BAEZ - 14
GATEWOOD - 8
WILDS - 4
LEWIS,D - 8
WASHINGTON - 4
HERNANDEZ,A - 4
VASQUEZ,O - 12
ROJAS - 8
DENNISTON - 14
CRUZ,C - 10
CHEN - 11
SMITH,SM - 28
SHEPHERD - 28
GARCIA,E - 11
KILAYKO - 12
CONEY - 23
DYE - 16
VASQUEZ,O - 12
DENNISTON - 14
CRUZ,C - 10
CHEN - 11
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
GARCIA,E - 11
CONEY - 23
HOLLIDAY - 8
DYE - 16
FARNIA - 12
VASQUEZ,O - 12
ROJAS - 8
WILLIAMS,A - 5
TA - 4
STATEN - 4
TUNG - 4
SCARBOROUGH - 4
KUO - 8
DENNISTON - 14
CRUZ,C - 10
CHEN - 11
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
GARCIA,E - 11
CONEY - 23
DYE - 16
FARNIA - 12
VALDENOR - 12
ALBA - 12
SMITH,SM - 28
SHEPHERD - 28
REHDER - 6
LANE - 8
KILAYKO - 12
BEAN - 8
JENKINS - 16
CONEY - 23
BAEZ - 14
GATEWOOD - 8
DYE - 16
FARNIA - 12
DICKSON - 4
JONES, D - 3
MOORE - 4
VALDENOR - 12
SMITH,SM - 28
DRUMMOND - 4
SHEPHERD - 28
REHDER - 6
LANE - 8
JENKINS - 16
CONEY - 23
BAEZ - 14
HOLLIDAY - 8
WILLIAMS,E - 7
ANGEL - 4
SHIN,J - 8
CO - 4
VALDENOR - 12
IRALDO - 8
SMITH,SM - 28
SHEPHERD - 28
SANTANA - 4
JENKINS - 16
CONEY - 23
BAEZ - 14
LEWIS,D - 8
SHIN,J - 8
KUO - 8
DENNISTON - 14
ANDREWS - 7
SMITH,SM - 28
SHEPHERD - 28
KILAYKO - 12
BEAN - 8
JENKINS - 16
CONEY - 23
BAEZ - 14
GATEWOOD - 8
WILDS - 4
LEWIS,D - 8
WASHINGTON - 4
VASQUEZ,O - 12
ROJAS - 8
IRALDO - 8
DENNISTON - 14
CRUZ,C - 10
CHEN - 11
SMITH,SM - 28
SHEPHERD - 28
GARCIA,E - 11
KILAYKO - 12
DYE - 16
WILDS - 1