View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
M Kan M Kan is offline
external usenet poster
 
Posts: 169
Default 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...