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