Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LIST OF THE NUMBERS, AND HOW MANY TIMES THEY REPEAT?
I GOT A COLUMN WITH A LIST OF ZIPCODES. I NEED TO GET A LIST OF EACH ZIPCODE
AND HOW MANY TIMES ITS REPEATED IN THE COLUMN? FIRST ZIPCODE IS A2, AND THE LAST IS A4464. LONG LIST ESPECIALLY IF I HAVE TO DO IT MANUALLY... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LIST OF THE NUMBERS, AND HOW MANY TIMES THEY REPEAT?
Run a quick pivot table on the column using the zip code in the Row column
and Count of Zip code in the Data area. -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "dperalta" wrote: I GOT A COLUMN WITH A LIST OF ZIPCODES. I NEED TO GET A LIST OF EACH ZIPCODE AND HOW MANY TIMES ITS REPEATED IN THE COLUMN? FIRST ZIPCODE IS A2, AND THE LAST IS A4464. LONG LIST ESPECIALLY IF I HAVE TO DO IT MANUALLY... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LIST OF THE NUMBERS, AND HOW MANY TIMES THEY REPEAT?
Where would i get the "count of zip code"....?
"M Kan" wrote: Run a quick pivot table on the column using the zip code in the Row column and Count of Zip code in the Data area. -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "dperalta" wrote: I GOT A COLUMN WITH A LIST OF ZIPCODES. I NEED TO GET A LIST OF EACH ZIPCODE AND HOW MANY TIMES ITS REPEATED IN THE COLUMN? FIRST ZIPCODE IS A2, AND THE LAST IS A4464. LONG LIST ESPECIALLY IF I HAVE TO DO IT MANUALLY... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LIST OF THE NUMBERS, AND HOW MANY TIMES THEY REPEAT?
I'm assuming you know how to generate a pivot table, if not:
http://www.kan.org/tips/excel_pivot_table_basic.php When you're in the layout view, drag the Zip Code field into both the row and data areas. In the data area, it might default to Sum of Zip Code. Double click it and select Summarize by Count -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "dperalta" wrote: Where would i get the "count of zip code"....? "M Kan" wrote: Run a quick pivot table on the column using the zip code in the Row column and Count of Zip code in the Data area. -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "dperalta" wrote: I GOT A COLUMN WITH A LIST OF ZIPCODES. I NEED TO GET A LIST OF EACH ZIPCODE AND HOW MANY TIMES ITS REPEATED IN THE COLUMN? FIRST ZIPCODE IS A2, AND THE LAST IS A4464. LONG LIST ESPECIALLY IF I HAVE TO DO IT MANUALLY... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can the number of iterations repeat many times as a loop?? | Excel Discussion (Misc queries) | |||
Repeat statements "x" number of times... | Excel Discussion (Misc queries) | |||
I have a long equation which I need to repeat 16 times! | Excel Worksheet Functions | |||
If I create a random list in Excel, does it repeat numbers? | Excel Worksheet Functions | |||
how do I get a calculation to repeat various number of times? | Excel Worksheet Functions |