G
Guest
Hello,
Can someone help me resolving this Custom filter issue that I m having on my
excel report? For some unknown reason I am unable to use the advance Custom
filter on the Contract end date column of my reports that I download from a
Business warehouse. All that I am trying to accomplish is to select anything
that is greater than equal to a particular value such as 11/01/2007. When I
use the Custom filter, I am getting nothing on my query result which is
inaccurate. When I try to do the same with manually (input the same value to
another column manually) it works, it's time consuming (about 800 cells).
I have even copied the column in question to a new column and format the
whole column as Date, but I still have the same problem.
I do have a spreadsheet that I'm willing to attach so that one can
experience the issue. Just provide me with an email address and I will send
the excel attachment.
Please help!
Best Regards,
Can someone help me resolving this Custom filter issue that I m having on my
excel report? For some unknown reason I am unable to use the advance Custom
filter on the Contract end date column of my reports that I download from a
Business warehouse. All that I am trying to accomplish is to select anything
that is greater than equal to a particular value such as 11/01/2007. When I
use the Custom filter, I am getting nothing on my query result which is
inaccurate. When I try to do the same with manually (input the same value to
another column manually) it works, it's time consuming (about 800 cells).
I have even copied the column in question to a new column and format the
whole column as Date, but I still have the same problem.
I do have a spreadsheet that I'm willing to attach so that one can
experience the issue. Just provide me with an email address and I will send
the excel attachment.
Please help!
Best Regards,