| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get a pivot table to ignore data
For example I have 2 columns of data. One column has names and the other a
score. A name can appear many times but I only want the pivot table to show and count the instances where a certain score was achieved. So if someone has passed they do not show on the pivot table but if they failed it will give the count of fails and the score for each. Robert 111 suggested a sumproduct function but I don't see how this would help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
| Refreshing Data within a pivot table | Excel Worksheet Functions | |||
| Pivot table Data area show/hide behavior | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
Threaded Mode
