Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Tables
Hello. Is there a way for pivot tables to count a field only if it contains a
string of characters? Example data: number results 1 a,b,c 2 a,b,c 3 a,b,c 4 b,c,d 5 b,c,d 6 a,b 7 e,f 8 a,b,c 9 a,b,c 10 a,b,c 11 b,c,d 12 b,c,d 13 a,b 14 e,f 15 a,b,c 16 a,b,c 17 a,b,c 18 b,c,d 19 b,c,d 20 a,b 21 e,f I want to count results that contain "a", and results that contain "b" etc. -- Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |