Advanced Filter

A

AbdulkareemAlhassni

New Member
Joined
Nov 16, 2018
Messages
41
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 ?
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
Re: A challenge in Advanced Filter

Hello Abdulkareem,

If you are using excel's "Advanced Filter", then just make sure the header name of the Criteria range cell is the exact same as the header in your original data. So, looking at the below sample, column D headers = "Date" & below that I have specified the criteria of ">=1-Jan-2019" & my advanced filter output is in range F1:G5

Another note is the date formats in your provided sample where it has / sometimes & - other times which might actually be a text cell

If you need to establish better understanding of the advanced filter, you can visit the below link :
https://trumpexcel.com/excel-advanced-filter/

Post back if you have further questions

ABCDEFG

<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B4C6E7]#B4C6E7[/URL] , align: center"]Activity Code[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B4C6E7]#B4C6E7[/URL] , align: center"]Date[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Date[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B4C6E7]#B4C6E7[/URL] , align: center"]Activity Code[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B4C6E7]#B4C6E7[/URL] , align: center"]Date[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]0101[/TD]
[TD="align: center"]14-Mar-19[/TD]
[TD="align: center"][/TD]
[TD="align: center"]>=1-Jan-2019[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0101[/TD]
[TD="align: center"]14-Mar-19[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]0201[/TD]
[TD="align: center"]13-Jan-19[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]0201[/TD]
[TD="align: center"]13-Jan-19[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]0203[/TD]
[TD="align: center"]01-Mar-19[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]0203[/TD]
[TD="align: center"]01-Mar-19[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]0203[/TD]
[TD="align: center"]01-Jan-19[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]0203[/TD]
[TD="align: center"]01-Jan-19[/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]0203[/TD]
[TD="align: center"]04-Jan-18[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]7[/TD]
[TD="align: center"]0340[/TD]
[TD="align: center"]03-Feb-18[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]8[/TD]
[TD="align: center"]0344[/TD]
[TD="align: center"]01-Jan-17[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

</tbody>
Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Re: A challenge in Advanced Filter

In column "E" you have to put the date condition for each record in column "D".


Before the filter:

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:84.59px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:127.37px;" /><col style="width:137.82px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Activity Code</td><td >Date</td><td > </td><td >Activity Code</td><td >Date</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">101</td><td style="text-align:right; ">14-mar-19</td><td > </td><td style="text-align:right; ">101</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">201</td><td style="text-align:right; ">13-ene-19</td><td > </td><td style="text-align:right; ">201</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">203</td><td style="text-align:right; ">01-mar-19</td><td > </td><td style="text-align:right; ">203</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">203</td><td style="text-align:right; ">01-ene-19</td><td > </td><td style="text-align:right; ">340</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">203</td><td style="text-align:right; ">04-ene-19</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">340</td><td style="text-align:right; ">03-feb-18</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">344</td><td style="text-align:right; ">01-ene-19</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">340</td><td style="text-align:right; ">01-mar-19</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="text-align:right; ">201</td><td style="text-align:right; ">13-ene-18</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:right; ">203</td><td style="text-align:right; ">01-mar-18</td><td > </td><td > </td><td > </td></tr></table>

After the filter:

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:84.59px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:127.37px;" /><col style="width:137.82px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Activity Code</td><td >Date</td><td > </td><td >Activity Code</td><td >Date</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">101</td><td style="text-align:right; ">14-mar-19</td><td > </td><td style="text-align:right; ">101</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">201</td><td style="text-align:right; ">13-ene-19</td><td > </td><td style="text-align:right; ">201</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">203</td><td style="text-align:right; ">01-mar-19</td><td > </td><td style="text-align:right; ">203</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">203</td><td style="text-align:right; ">01-ene-19</td><td > </td><td style="text-align:right; ">340</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">203</td><td style="text-align:right; ">04-ene-19</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">340</td><td style="text-align:right; ">01-mar-19</td><td > </td><td > </td><td > </td></tr></table>





 
Upvote 0
Re: A challenge in Advanced Filter

Try this

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:84.59px;" /><col style="width:153.03px;" /><col style="width:47.52px;" /><col style="width:127.37px;" /><col style="width:137.82px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Activity Code</td><td >Date</td><td > </td><td >Activity Code</td><td >Date</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">101</td><td style="text-align:right; ">14-mar-19</td><td > </td><td style="text-align:right; ">101</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">201</td><td style="text-align:right; ">13-ene-19</td><td > </td><td style="text-align:right; ">201</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">203</td><td style="text-align:right; ">01-mar-19</td><td > </td><td style="text-align:right; ">203</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">203</td><td style="text-align:right; ">01-ene-19</td><td > </td><td style="text-align:right; ">340</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">203</td><td style="text-align:right; ">04-ene-19</td><td > </td><td style="text-align:right; ">101</td><td >*2019*</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">340</td><td style="text-align:right; ">03-feb-18</td><td > </td><td style="text-align:right; ">201</td><td >*2019*</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">344</td><td style="text-align:right; ">01-ene-19</td><td > </td><td style="text-align:right; ">203</td><td >*2019*</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">340</td><td style="text-align:right; ">01-mar-19</td><td > </td><td style="text-align:right; ">340</td><td >*2019*</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="text-align:right; ">201</td><td style="text-align:right; ">13-ene-18</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:right; ">203</td><td style="text-align:right; ">01-mar-18</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="text-align:right; ">201</td><td >year 2019 some text</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="text-align:right; ">203</td><td >some string mar 2019</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="text-align:right; ">203</td><td >data mar 2018 data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="text-align:right; ">203</td><td >data mar 2020 data</td><td > </td><td > </td><td > </td></tr></table>
 
Upvote 0
Re: A challenge in Advanced Filter

DanteAmor said:
Try this
Click to expand...

Great its working but i still have another issue,

How can i tell this filter to :

If there is any other Code other the ones specified with a Date >=1/1/2019 or has a text format of *2019* to include it ?

the above filter is only filtering with regards to the provided activities, but i have other activites within 2019 that i DONT want to exclude.
 
Last edited by a moderator:
Upvote 0
Re: A challenge in Advanced Filter

I think i found two ways: i will test them now:

First method:

ABCDE
Activity CodeDateActivity CodeDate
>=01-01-2019
>=01-01-2019
>=01-01-2019
>=01-01-2019
*2019*
*2019*
*2019*
*2019*
*2019*
>=01-01-2019
year 2019 some text
some string mar 2019
data mar 2018 data
data mar 2020 data

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]2[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]14-mar-19[/TD]

[TD="align: right"]101[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]3[/TD]
[TD="align: right"]201[/TD]
[TD="align: right"]13-ene-19[/TD]

[TD="align: right"]201[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]4[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]01-mar-19[/TD]

[TD="align: right"]203[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]5[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]01-ene-19[/TD]

[TD="align: right"]340[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]6[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]04-ene-19[/TD]

[TD="align: right"]101[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]7[/TD]
[TD="align: right"]340[/TD]
[TD="align: right"]03-feb-18[/TD]

[TD="align: right"]201[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]8[/TD]
[TD="align: right"]344[/TD]
[TD="align: right"]01-ene-19[/TD]

[TD="align: right"]203[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]9[/TD]
[TD="align: right"]340[/TD]
[TD="align: right"]01-mar-19[/TD]

[TD="align: right"]340[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]10[/TD]
[TD="align: right"]201[/TD]
[TD="align: right"]13-ene-18[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]11[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]01-mar-18[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]12[/TD]
[TD="align: right"]201[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]13[/TD]
[TD="align: right"]203[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]14[/TD]
[TD="align: right"]203[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]15[/TD]
[TD="align: right"]203[/TD]

</tbody>



Second Method:



ABCDEF
Activity CodeDateActivity CodeDate
>=01-01-2019=B2>=01-01-2019
>=01-01-2019=B2=2019
>=01-01-2019
>=01-01-2019
*2019*
*2019*
*2019*
*2019*
year 2019 some text
some string mar 2019
data mar 2018 data
data mar 2020 data

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]2[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]14-mar-19[/TD]

[TD="align: right"]101[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]3[/TD]
[TD="align: right"]201[/TD]
[TD="align: right"]13-ene-19[/TD]

[TD="align: right"]201[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]4[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]01-mar-19[/TD]

[TD="align: right"]203[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]5[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]01-ene-19[/TD]

[TD="align: right"]340[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]6[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]04-ene-19[/TD]

[TD="align: right"]101[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]7[/TD]
[TD="align: right"]340[/TD]
[TD="align: right"]03-feb-18[/TD]

[TD="align: right"]201[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]8[/TD]
[TD="align: right"]344[/TD]
[TD="align: right"]01-ene-19[/TD]

[TD="align: right"]203[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]9[/TD]
[TD="align: right"]340[/TD]
[TD="align: right"]01-mar-19[/TD]

[TD="align: right"]340[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]10[/TD]
[TD="align: right"]201[/TD]
[TD="align: right"]13-ene-18[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]11[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]01-mar-18[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]12[/TD]
[TD="align: right"]201[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]13[/TD]
[TD="align: right"]203[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]14[/TD]
[TD="align: right"]203[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] [/URL] , align: center"]15[/TD]
[TD="align: right"]203[/TD]

</tbody>


Dont know which one is better ?
 
Upvote 0
Re: A challenge in Advanced Filter

If you put this

[TABLE="width: 138"]
<colgroup><col></colgroup><tbody>[TR]
[TD]>=01-01-2019[/TD]
[/TR]
[TR]
[TD]*2019*


[/TD]
[/TR]
</tbody>[/TABLE]


Then it is not necessary to put this

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:127.37px;" /><col style="width:137.82px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >D</td><td >E</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Activity Code</td><td >Date</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">101</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">201</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">203</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">340</td><td >>=01-01-2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">101</td><td >*2019*</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">201</td><td >*2019*</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">203</td><td >*2019*</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">340</td><td >*2019*</td></tr></table>


Since all activities are in *2019* or greater than 01/01/2019
 
Upvote 0
Re: A challenge in Advanced Filter

Ok thank you you were right,

last question,

Assume i have another two columns, and the way am filtering (Main Source) using the Sub-Sub-Activity:

Filter is used to get its "Sub-Activity" values

and then i wanna run a different filter using "Sub-Activity" values on the (Main Source) again

Is there a more effcient way of doing it rather than

1.Filter Main source
2. Obtain Data
3. Filter Main source again "using obtain data"


Before the filter:

ACDEFGH
Activity CodeSub-ActivitySub-Sub-ActivityDateSub-Sub-ActivityDate
>=01-01-2019
>=01-01-2019
>=01-01-2019
>=01-01-2019

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]2[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]101-1[/TD]
[TD="align: right"]John[/TD]
[TD="align: right"]14-mar-19[/TD]

[TD="align: right"]John[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]3[/TD]
[TD="align: right"]201[/TD]
[TD="align: right"]201-1[/TD]
[TD="align: right"]Alpha[/TD]
[TD="align: right"]13-ene-19[/TD]

[TD="align: right"]Alpha[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]4[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]203-1[/TD]
[TD="align: right"]Rock[/TD]
[TD="align: right"]01-mar-19[/TD]

[TD="align: right"]Micky[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]5[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]203-2[/TD]
[TD="align: right"]Rock[/TD]
[TD="align: right"]01-ene-19[/TD]

[TD="align: right"]Sugar[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]6[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]203-3[/TD]
[TD="align: right"]Micky[/TD]
[TD="align: right"]04-ene-19[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]7[/TD]
[TD="align: right"]340[/TD]
[TD="align: right"]340-1[/TD]
[TD="align: right"]Sugar[/TD]
[TD="align: right"]03-feb-18[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]8[/TD]
[TD="align: right"]340[/TD]
[TD="align: right"]340-2[/TD]
[TD="align: right"]Sugar[/TD]
[TD="align: right"]01-ene-19[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]9[/TD]
[TD="align: right"]340[/TD]
[TD="align: right"]340-3[/TD]
[TD="align: right"]Sweet[/TD]
[TD="align: right"]01-mar-19[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]10[/TD]
[TD="align: right"]201[/TD]
[TD="align: right"]201-2[/TD]
[TD="align: right"]Beta[/TD]
[TD="align: right"]13-ene-18[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]11[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]203-4[/TD]
[TD="align: right"]Micky[/TD]
[TD="align: right"]01-mar-18[/TD]

</tbody>


After the filter:

>=01-01-2019
Sugar>=01-01-2019

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]7[/TD]
[TD="align: right"]340[/TD]
[TD="align: right"]340-1[/TD]
[TD="align: right"]Sugar[/TD]
[TD="align: right"]03-feb-18[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]8[/TD]
[TD="align: right"]340[/TD]
[TD="align: right"]340-2[/TD]
[TD="align: right"]Sugar[/TD]
[TD="align: right"]01-ene-19[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]11[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]203-4[/TD]
[TD="align: right"]Micky[/TD]
[TD="align: right"]01-mar-18[/TD]

</tbody>

Hope you got what i need. :)
 
Last edited by a moderator:
Upvote 0
You must log in or register to reply here.

Similar threads

Red over White
  • Solved
Filter by specific days, months and years
Replies
3
Views
299
Red over White
Red over White
T
  • Question Question
VBA code to autofill based on a date?
Replies
3
Views
174
Joe4
Joe4
M
  • Question Question
Drop down list with selection containing Alpha and Numeric characters not working
Replies
1
Views
126
myall_blues
myall_blues
Jyggalag
  • Solved
Formula to calculate between dates
Replies
4
Views
707
Peter_SSs
Peter_SSs
O
  • Question Question
Limit filter list to unique values
3 4 5
Replies
43
Views
1K
ollyhughes1982
O

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top