Running Excel 365 Pro Plus. Have a table with approximately 100,000 rows with duplicate entries. Have been using conditional formatting and custom filter to identify and sort these entries. Takes 20-30 minutes to run. However, when I want to use the custom filter for another task, as soon as I select custom filters the previous entries are still in place and the sort immediately runs again without my selecting it to execute. Is there a way to be sure the custom filter comes up clean between different sorting tasks?
Thanks in advance,
jaustin
Thanks in advance,
jaustin