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. This feature is extremely useful when you want to see how the analysis
changes for a different subset of the data.
If you are on an analysis report, the saved filter (if any) will be applied to
the dataset. You can modify the filter and return to the analysis and click
Recalcuate to apply the new filter, or you can start a new analysis to reuse the
The save filter feature in version 5.10 or later works with almost all filter
conditions: filter by value, by condition, by color/fill/icon, above/below
average, top/bottom items, and so on. There is one limitation: filtering to
multiple dates. If you filter to more than 2 dates, add-ins such as Analyse-it
cannot retrieve the list of values to filter to. This is a limitation of
Microsoft Excel and unfortunately it hasn’t been remedied in the last few years
so it is low on Microsoft’s priorities. If this is seriously affecting you,
please get in touch with Microsoft and ask them to resolve this limitation for
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 Number Filters > Greater Than, and then enter 40 as the cut-off point:
We've been developing intuitive high-quality statistical software at an affordable price, backed up by fast friendly customer service for over 25 years...
Office hours: 9am-5pm GMT Mon-Fri
It's Tuesday 5:02 PM and the office is closed - e-mail us and we'll get back to you as soon as possible.