If the list is large, clear (Select All) at the top, and then select the specific text values to filter by. The list of text values can be up to 1,000 items. In the list of text values, select or clear one or more text values to filter by. Locate a column that contains alphanumeric data. Learn about possible issues with filtering data You can filter by a list of values or by criteria. The resulting information would contain only data that applied to France in 2008. Thus, you might first filter on data from the year 2008, and then on data from France. Each additional filter that you apply works only the subset of data produced by the current filter, and therefore further reduces the subset of data. You can also filter by more than one column. Filtered data displays only the rows that meet criteria that you specify and hides rows that you do not want to display. Filtering data is a quick and easy way to create a subset of data in a range of cells or in a table column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |