Use an Excel filter to show only the rows that match a value or meet a condition. Rows that do not match the condition are hidden temporarily, and subsequent data analysis excludes them.
Note: Be aware that the active filter is not saved with the analysis. When you recalculate an analysis the rows currently visible are analyzed, regardless of the filter you used when creating the analysis. This feature is extremely useful when you want to see how the analysis changes for a different subset of the data. You can change the filter criteria and then recalculate or clone the analysis to see the impact.
On the Analyse-it ribbon tab, in the
Dataset group, click
Filter to show filter icons on the active dataset. If
a filter is active click Filter to remove the filter and
show all rows in the dataset.
Click the drop-down button alongside a variable, and then either select the values to match, or click Number Filters to choose a condition.
Create or recalculate an analysis to see the effect of the filter.
To filter to Female cases only, click the drop-down button alongside Sex, and then
select Female in the list of values to match
To filter to cases where the subject is older than 40, click the drop-down button
alongside Age, and then click
, and then enter 40 as the cut-off point: