Advanced Filter

[AbdulkareemAlhassni]

Dear all,

i have a table as follows

Activity Code Date
0101 3/14/2019
0201 1/13/2019
0203 3/1/2019
0203 1-1-2019
0203 1-4-2018
0340 2/3/2018
0344 1/1/2017

..................
When i apply the following filter

i get the date for our Purchase starting from 2019 and forward:

Date
*2019*
>=1/1/2019


----------------

The actual filter i want is i want to filter the Date with respect to specific Activity Codes, so

what i actually runs as a filter ( which is what i want )

..................
When i apply the following filter


Activity Code Date
0101 *2019*
0201 >=1/1/2019
0203
0203
0203
0340
0344


The problem is here i keep getting dates before 2019 such as 2018. because the filter is reading all " Activity Code" and returns all of them and " Keeps ignoring the "Date Filter" somehow,

how can i fix this ?

 

[DanteAmor]

Re: A challenge in Advanced Filter

One way is to create a macro and press a button. But even so, if you increase the columns of your data, you will have to modify the macro code.

 

[AbdulkareemAlhassni]

Re: A challenge in Advanced Filter

One way is to create a macro and press a button. But even so, if you increase the columns of your data, you will have to modify the macro code.

i will just let the macro reads till the end of the excel sheet column.

anyhow i really appreciate your cooperation <3

 

[DanteAmor]

Re: A challenge in Advanced Filter

Your welcome. Let me know if you need help with the macro.