Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas for pivot table data
Hi, Is there a straightforward way to make the following kind of check of a large dataset? The dataset looks like this: year ethnicgroup agegrouping city number 1998 latin 15-19 London 989 1998 latin 20-24 London 788 1998 latin 25-29 London 227 1998 latin 30-34 London 675 2000 asian 20-25 London 229 2000 asian 30-34 London 221 2000 asian 50-55 London 387 2000 caucasian 16-24 New York 3356 2000 caucasian 60-65 New York 372 This is a very large dataset covering many cities, age groupings and ethnic groups. There is standard set of agegroupings by which most cities report their data: for example ages 15-19,20-24,25-29,30-34, and so on. Some cities report in this standard way. Others don't but are non-standard, for example, NY 2000 age grouping 16-24. I'd like to separate out of the dataset all those cities with corresponding year, ethnic group and values which use the standard age groupings and put them in one excel worksheet. And to put the remaining non-standard data (cities and their corresponding year and ethnicity info that don't use this standard set of age groupings) in another excel worksheet. How would you suggest I do this? I'd appreciate any ideas or suggestions on how to go about this. Matthew Donnelly *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Pivot Table Data Values to Create Formulas | Excel Discussion (Misc queries) | |||
Formulas in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table formulas | Excel Discussion (Misc queries) | |||
Pivot table formulas | Excel Worksheet Functions | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions |