What are the steps for filtering in ms excel

 Filtering in M.S Excel

          Excel is a wonderful package to get the required records from hundred and thousand records. It performs miracles while searching the records. It convert the names of records into either ascending or descending order. Let us see how it performs.

We will discuss about the following topics.

• Placing the records in an order.
• Searching the required records.
• Searching the records based on more than one criteria.

Placing the records in an order

          Excel sorts the records either into ascending or descending order based on same criteria.

Step 1: Select the data which we want to place in an order. 

 

Step 2: Click on Data and click on sort. The records are sorted alphabetically

Step 3: If you want to place the records from down to top click on ZA icon

Searching for the required records in Excel

         Excel provides a list of top two or three students who have secured ranks among hundred or thousand of students. Let us know how to get the list of the top students.

Step 1: Select the required cells.

Step 2: Click on Data > Filter.

Step 3: Consequently, Filter buttons appear in front of each filed.

Step 4: We need the top marks in the subject 'eng'. Click on the filter under the field 'eng'.

Step 5: Click on Number Filters and select Top 10 in the submition.

Step 6: Type the required number of students whose top marks are required.

Step 7: Click on OK.

Step 8: Consequently, the list of three students who got highest marks in the subject 'Eng' appear.

Searching records based on more than one criteria

            Some times we search for records which are based on more than one criteria. For example we need the list of student who got more than 34 marks but also less than 80. We can obtain the list by using Auto Filter command.

Step 1: Select the required cells.

Step 2: Click on Data > Filter. Consequently, Auto Filter buttons appears in data fields.

Step 3: Click on a particular data filter and select Number Filter > Custom Filter.

Step 4: Select the required criteria (i.e., equals 60 and but less than 80 marks.)

Step 5: Click on OK.

Step 6: See the result. The marks of students who got more than 60 but less than 80 appear.

Note: In order to remove filter for each filed and to get the database in a normal way, click on filter icon.