Filter is a frequently used feature in excel. The ‘filter’ option is used when you want to display only those records which meet certain criteria. For example you want to filter the samples which are marked as passed as shown in below.
Step 1. Select a cell within the data range. Go to ‘Sort & Filter’ option in ‘Home’ tab.
Step 2: Select the ‘Filter’ option from the drop down.
Step 3: A drop down option will appear on the columns. Click on that. By default the ‘Select All’ option is checked.
Step 4: To filter only the samples which are passed, uncheck the ‘Select All’ option.Check the option ‘Pass’.
Your excel displays only the samples which are passed.