| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
