Most valuable professional
  • Hot Topics

Excel Advance Filter Macro

Hi All, I have data in below format :- Now I want to add a filter as below mentioned criteria :- 1) Picklisted : Should be New 2) 410(A) : Should remove latest 6 dates from filter 3) GR1 : Should be False 4) GR01 : Should be select all numbers & numbers where 2 numbers mentioned with text Rej. I tried by myself with without macro with advance filter , but unable to found any solution, how to filter out latest 6 dates from filter. Please assist. State 0 NSW NSW NSW NSW 0 QLD QLD QLD QLD WA WA

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of February 5, 2018.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel