is used only for a single criteria on data, whereas Standard filter is used for multiple critieria. Step : Select Data → Filter → Standard Filter. Now, the entire data is selected and "Standard Filter" dialog box dispalys as shown in Figure . .
Step : Select the column heading from the “ Field name ” list box for the first criteria. Select conditional opeator such as >, <, = etc., from “ Condition ” list box. Type or select the value of critera in the “ Value ” box. Step : Select the one of the logical operator (AND / OR) from “ Operator ” list box to fix second criteria.
Follow the step , for the next criteria. Step : Click “ Ok ” to finish. Example for Standard filter: If you want to filter the records of “XII-H2” students of group code from the Figure . .
Step : Select Data → Filter → Standard Filter Now, “Standard Filter” dialog box appears as in Figure . . Step : In “Standard Filter” dialog box, select the first criteria: Select Field name as "Group code". Select Condition as "=".
Type or select Value as " ". Step : To select the second criteria: Select Operator as “AND”. Select Field name as "Class". Select Condition as "= ".
Type or select Value as "XII- H2". Figure . Standard Filter Step : Click “OK” Now, the table displays only the records which match the given two criteria. Refer Figure .
. To Remove Standard Filter: Select Data → Filter → Remove Filter Figure . XII-H2 students of Group . Applying Validation Validation will limit the data to be entered in the selected row/column/cell.
For example, in the student database, the maximum roll no is . Hence, if the user enters a roll no above , it should give an error message. Step : Enter Roll No in a cell A1 and select the entire column (column A) Step : select Data → Validity, the validity dialogue box appears. Select Criteria tab, Select whole numbers in the Allow field.