« Importing Tabular Data : CSV Files | Main | Data Filtering : Advanced Filter »
October 13, 2004
Data Filtering : Standard Filter
In the previous article on Data Filtering - we looked at the AutoFilter option.We will now look at the Standard Filter.
For this example, we will be using the same data as the AutoFilter option. The Standard Filter is invoked by Data-FIlter-Standard FIlter - as is shown below.
The Standard Filter dialog box opens up. In the first simple example, we will just select the rows where Sales exceeded $9000. The Field name, Condition and Value fields are filled by selecting the desired values from the drop down lists presented. In the case of the Value field, you can also enter your own desired value in place of one of the drop down options.
Once you've filled in the required fields, hit OK for the filters to take effect - see below. Please note the row numbers indicate that we have filtered, not deleted the unwanted data - at least for the purposes of this particular analysis.
Posted by Dave at October 13, 2004 06:53 AM
Comments
How can I delete only the selected rows and not every row that is in between the selected ones?
Posted by: Luis Mendes at February 2, 2006 12:58 PM
How to filter data by string.
Example
a-100
b-200
c-200
d-100
e-200
I want to filter data thar contains string -200
Thank You
Posted by: Djole at February 28, 2006 09:01 AM