- Filter the data
- Sort the data
The Search Box in the filter interface permits you to search for text and numbers. To find this function, head to the Data tab then in the "Sort &" Filter group, click "Filter". There should be an arrow in the header that on clicking displays a list in which you can make filter choices.
Use the Search Box to enter the dates you require (Excel accepts text or numbers depending on what you have used). If you need to filter data by specifying conditions then you need to create custom filters to narrow down the data. To do this:
- In the list, point to either Number Filters or Text Filters. A filtering menu should appear.
- Indicate a condition and then choose or input criteria. If required, click the "And" button to pool criteria or select the "Or" button if you want only one of the manifold conditions to be met.
- Click "OK" to engage the filter and receive your desired outcomes.