Some partners have started using Excel but are not yet able to filter out the data that meets the conditions. This section introduces the steps for filtering out the data that meets the conditions in Excel. For those who don’t know yet, please follow the editor to learn. I hope it will be helpful to you. helped.

Open Excel, create the personnel information table, click the file in the upper right corner, then click Save, and select the save path.

Enter the main editor’s page and click the ‘Data’ column in the main menu bar on the upper right.

After entering the data, use the mouse operation to lock the area to be filtered, usually all the areas are locked.

After locking, look for a ‘Filter’ button in the function bar below. Since there are many buttons in the function bar, ‘Filter’ is probably in the middle.

After clicking Filter, several small tips will appear in the first row of your worksheet. Click on the small tips.

After clicking, a filtering window will pop up, select the conditions you want to select, and click Confirm.

After you have set all the conditions, the remaining elements are the members that meet the conditions.

The above explains the steps for filtering out qualified data in Excel. I hope friends in need can learn it.