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 |
All times are GMT +1. The time now is 07:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com