When you do, you’ll notice new list box arrows at the top of each column. Click that list box arrow and you’ll have several options for selecting information. You’ll be able to select specific values, ranges of values, top n values and so-forth. It’s really a great way to help manage large number of rows of data – and make it more straightforward to work with in your analysis.
If you have multiple columns of data, you can select first from one, then the other. The filters will, in essence, be combined. For example if one column was State and one was City, working with the entire data set could be tedious. Add in the AutoFilter and then select State of Arizona. Next, you can select Miami and you’ll only be looking at the Miami in Arizona, not in Florida. Simple example, but hopefully you get the idea.
To return to “regular” unfiltered mode, just select Data, Filter, AutoFilter again and the list boxes will be removed.
Now! easily filter your data in Microsoft Excel.
0 comments:
Post a Comment