| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Layout in Excel
I have several workheets list of zip codes and the count of how many people
from each zip code signed up in a particular region. I want to combine the information on a master list . If there are any duplications, I want to combine the code and the count. Sheet 1: 55010 16 Sheet 3: 55010 2 to Read: Master list 55010 18 What can I do, I couldn't quite get a Pivot Table to do it right. |
|
#2
|
|||
|
|||
|
I'd copy all the data into one sheet, then start the pivottable.
marychi wrote: I have several workheets list of zip codes and the count of how many people from each zip code signed up in a particular region. I want to combine the information on a master list . If there are any duplications, I want to combine the code and the count. Sheet 1: 55010 16 Sheet 3: 55010 2 to Read: Master list 55010 18 What can I do, I couldn't quite get a Pivot Table to do it right. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
| Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Linear Mode
