I can't seem to find any easy solution - hope someone can help. I have 30,000 rows of data that all begin with various 30+ common digits (11-xxxx, 12-xxxx, 18-xxxxx) and have rows that indicate yearly sales quantity and dollar volumes etc. I created a pivot table which gives me all the data I want. Now I want to create a label filter which contains only certain pre-fixes, such as 11, 22, 85, 98 & 99 ... while ignoring all the rest of the data. I have tried to filter using 'Begins with' but I can't seem to choose multiple beginning digits. I have tried using a comma, semi colon, colon as a separator... but nothing is working. I don't see an 'AND' command anywhere either. These numbers are not in a given range and there are hundreds of data points for each 2 digit pre-fix, so manually selecting them really isn't an option either, but I'd like to see them all together in one list.
Is this possible?
Thanks.
Terri
Bookmarks