Forum Discussion
Filter not capturing all content
It could be a blank row within the data set. If you don't specify the range when applying the filter Excel will presume the 'current region' (If you're active within the data and press ctrl+a you can see what's being considered part of the current region. These rows will be considered by the filter).
If there are blanks in the data set, you can remove the filter, make a point to select all your data (header included) and then apply the filter. Sorting works on the same principle.
It could be a blank row within the data set. If you don't specify the range when applying the filter Excel will presume the 'current region' (If you're active within the data and press ctrl+a you can see what's being considered part of the current region. These rows will be considered by the filter).
If there are blanks in the data set, you can remove the filter, make a point to select all your data (header included) and then apply the filter. Sorting works on the same principle.
Thank you
This is in fact what had happened there was a blank row that had somehow snuck in (the joys of shared data) without me seeing it and it was causing the issues with my sort.
