Excel Video 285 adds some real power to your filtering skills by introducing Label Filters. Label Filters allow you to filter by whatever is in the Row or Column Label. In our example today, we’ll filter text data. It’s easy to select labels that begin with, don’t begin with, end with, don’t end with, contain, don’t contain, etc. anything you’re looking for. For example, if you have a list of providers and you want to find all of the physician assistants in the list, you could filter on labels ending with PA. If you’re looking for all of the E&M codes, you could filter for labels beginning with 99.
At the end of the video I told you we’d move on to Value Filters next, but there’s one more thing I want to show you on Label Filters. Stay tuned next time to see what happens when we put a date field in the Row Labels area. I look forward to seeing you then.