Thread: Pivot Tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mike Archer Mike Archer is offline
external usenet poster
 
Posts: 52
Default 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