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
|