Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 793
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to Count the number of times a value occurs within a dt range Gina[_2_] Excel Worksheet Functions 9 July 4th 08 10:19 PM
I want to see how many times each number occurs in an array. eingram Excel Discussion (Misc queries) 3 June 21st 06 02:53 AM
Counting the number of times more than 1 variable occurs chrisdedobb Excel Discussion (Misc queries) 5 January 3rd 06 06:20 PM
How to count the number of times something occurs within a certain month Joyce Excel Worksheet Functions 1 October 18th 05 06:11 PM
How do I count the times a number occurs in a given criteria? w_aller Excel Discussion (Misc queries) 2 February 3rd 05 09:06 AM


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"