Search specific information in a data table

You can easily search a data table for information that matches specific search criteria. The matching cells are identified using a color of your choice, so that you can easily identify the items which match your search criteria. For more information on how to search specific information in a data table, see the following instructions.

See also

Select an item in a data table

View the different details of a data table

Return data table information to your calculations

Search specific information in a data table

Click Search.
The Search criteria dialog box appears.
In the Search for list, select the item that you want to search for.
In Criterion 1, set the condition which you want to use in your search.
If necessary, in Criterion 2, set another condition to limit your search further.
If you have defined Criterion 2, select whether Criterion 2 is additional or alternative to Criterion 1 by selecting either And or Or.
If you want to apply search conditions for other items, repeat steps 2–5 for each item.
To search the data table, click OK.
The data table re-displays, and highlights the items that match your search criteria.

To view the details of the matching items, click the Variables tab.

Change the search criteria for a data table

Click Search.
The Search criteria dialog box appears.
Select the item whose criteria you want to change.
Change the search criteria according to your needs.
- If you want to remove all search criteria, set Criterion 1 to None.
Click OK.

Clear a search

To clear your search, click Edit > Clear search.

Your search is cleared.