When exploring data it can be useful to analyse a subset of the cases from the dataset, for example to see summary statistics for just Male or Female subjects.
To allow analysis of just a subset of cases Analyse-it only analyses the cases that are visible on the worksheet. Observations on hidden rows will not be included in the analysis. Rows can be manually hidden to exclude them from analysis, or Excel's AutoFilter or Advanced Filter can be used to hide rows based on conditions:
IMPORTANT When Analyse-it updates a report it will analyse the cases that are currently visible in the dataset, rather than the cases that were visible when the analysis was first performed.
To use AutoFilter to limit analysis to a subset of the dataset: