Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to Count the number of times a value occurs within a dt range | Excel Worksheet Functions | |||
I want to see how many times each number occurs in an array. | Excel Discussion (Misc queries) | |||
Counting the number of times more than 1 variable occurs | Excel Discussion (Misc queries) | |||
How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) |