User's Manual Part 2

♦137♦ MEGAM.O.L.E.® Help System Guide
To use the Special option:
1) Select Special to select data run rows within a range of values. There are
multiple options to select information to filter by clicking the appropriate relational
operators option button. The user can either select data from a populated list or
type it in the text box on the top of the column.
= equal to >= greater than or equal to
> greater than <= less than or equal to
< less than <> Not equal to
2) Select a data filter by:
• Clicking the greater than relational operator option button beside the left data
column.
• Click a parameter value from the list or type it in the text box.
• Click the AND logical operator option button.
• Click the less than relational operator option button beside the right data column.
• Click a parameter value from the list or type it in the text box.
The Clear command button can be selected at any time to clear the
selections and the new values can be selected.
3) Click the OK command button to accept the selected data filters or Cancel to
return to the Spreadsheet Page Tab without executing the filter request.