Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In this course, Dennis Taylor shares easy-to-use database commands and methods for maintaining an Excel database. The course covers sorting, adding subtotals, auto-filtering, and using the Excel Advanced Filter feature and specialized database functions.
In this worksheet consisting of scientific data, in Column B we see codes. If you work with coding structures you know how strange they can be sometimes. It just so happens that based on the codes that we're seeing here, we need to find those that have B in the second position, like this one, and then later the letter Q. Now, here is a Q right behind it. There might be some others. Here is a Q that's a few characters removed. We want to find all situations where B is the second letter and then later there's a Q. So let's apply a filter to this data. And click the drop arrow for Code, Text Filters > Custom Filter.
Not equals, but begins with, anything, we don't care what it begins with, and like in our previous example, question mark, then B is the second character. The asterisk symbol means 0, 1, or many characters. So after the B, either immediately or one or two or three or four characters later, a Q is going to cover all those situations. I'll click OK and in our results we see B in the second position in all of these.
Here the Q occurs immediately after the B. Here it's about four characters away. Here it's immediately after. Here it's two characters away. So in all cases. So just seeing one example of how you might use question mark and asterisk and sometimes together like we saw here, you see some very unusual constructions. So you can imagine the occasional need, particularly with code numbers, to pull out some very unusual data by way of a filter.
Find answers to the most frequently asked questions about Managing and Analyzing Data in Excel 2010.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.