You can search for a value in time series and paired data sets. You can set a tolerance to search within or you can search for values less than or greater than a specified number.
You can tabulate the records that match your specifications. Those values will be highlighted in red. To search for a value:
1. Select the data sets that you want to search. From the Tools menu, click Search for Value, the Enter Value to Search for dialog box will open (see below).
2.From the Enter Value to Search for dialog, enter the value you would like to find in the Search for box. If you would like to search within a tolerance for this value, enter the range in the Within +- box.
3. By default, the search is set to find the exact value, give or take the Within value. However, you can choose to search for values Greater Than, Less Than, Greater than or Equal to, or Less than or Equal to the Search for value.
4. Once you are finished selecting your search criteria, click OK.
The Found Values message box will appear (below) listing all selected data sets that meet your search criteria.
6.To tabulate the search findings, click Yes on the Found Values window. A table will display listing all values that meet the search criteria in red, see below.
