When using advanced filter, I noticed that when the function works, it works beautifully.
However, once in a while, the filter function would fail (i.e. after selecting the list range and the criteria range in advanced filter and click OK, nothing happens to the original content in the List range). When the filter function fails, I have to copy and paste the content and that criteria into a new workbook and repeat the procedure. If I simply repeat the advanced filter operation in the original workbook, somehow I could not get the advanced filter to work.
Anyone knows how many different reasons the advanced filter would fail to filter a spreadsheet ?
Bookmarks