Hello,
I am using Advanced Filter to filter a list. See the screenshot enclosed.
The correct filter result here would be the yellow cells (rows 6 to 10).
However, the filter result only shows rows 7 to 10.
Any idea what I am doing wrong here ? The cells in column A are formatted as 'text'.
Thanks.
I am using Advanced Filter to filter a list. See the screenshot enclosed.
The correct filter result here would be the yellow cells (rows 6 to 10).
However, the filter result only shows rows 7 to 10.
Any idea what I am doing wrong here ? The cells in column A are formatted as 'text'.
Thanks.