• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

advance filter

R

r_2

Member
Hi,


iam using 2007 & unable to find out the way of advance filter.

I need to filter between range (ex-06-July-2012 00:00 to 16-Dec-2012 18:00)& i have rows upto ag & upto 800 column.


Pls advise.
 
Hi r_2


Following links might interest you:


http://chandoo.org/wp/2011/10/10/how-to-use-advanced-filters/

http://chandoo.org/wp/tag/advanced-filters/

http://www.contextures.com/xladvfilter01.html


..It will be helpful if you upload a sample file.


Faseeh
 
Hi, need filter the column( stock in date) range-6-DEC TO 11 JAN:

[pre]
Code: 
item code	order Date	stock in Deliver	stock in Date	complete Date
1	01-Dec-2012 12:07	03-Dec-2012 11:30	03-Dec-2012 11:40	04-Dec-2012 15:23
2	03-Dec-2012 11:53	05-Dec-2012 00:00	06-Dec-2012 00:00	07-Dec-2012 16:36
4	08-Dec-2012 00:00	10-Dec-2012 11:00	10-Dec-2012 12:26	11-Dec-2012 16:30
7	01-Dec-2012 11:40	08-Dec-2012 10:35	08-Dec-2012 11:36	10-Dec-2012 12:30
10	08-Feb-2013 15:00	09-Feb-2013 11:00	09-Feb-2013 12:32	09-Feb-2013 12:43
11	11-Dec-2012 00:00	12-Dec-2012 00:00	12-Dec-2012 00:00	14-Dec-2012 11:39
12	02-Jan-2013 00:00	03-Jan-2013 00:00	03-Jan-2013 06:00	04-Jan-2013 14:33
14	24-Dec-2012 00:00	26-Dec-2012 00:00	26-Dec-2012 00:00	04-Jan-2013 13:57
15	27-Dec-2012 00:00	28-Dec-2012 00:00	28-Dec-2012 00:00	04-Jan-2013 14:02
16	28-Jan-2013 10:00	28-Jan-2013 12:00	28-Jan-2013 15:00	28-Jan-2013 10:00
17	01-Jan-2013 10:30	18-Jan-2013 12:00	18-Jan-2013 13:21	21-Jan-2013 12:10
18	28-Dec-2012 10:00	31-Jan-2013 10:30	31-Jan-2013 15:00	31-Jan-2013 13:00
22	18-Feb-2013 15:00	19-Feb-2013 10:00	19-Feb-2013 13:00	18-Feb-2013 15:00
23	01-Jan-2013 10:00	11-Jan-2013 11:00	11-Jan-2013 14:00	15-Jan-2013 15:23
24	01-Jan-2013 10:00	14-Jan-2013 11:00	14-Jan-2013 12:00	18-Jan-2013 13:30
25	31-Jan-2013 15:00	01-Feb-2013 12:00	01-Feb-2013 13:00	01-Feb-2013 13:00
[/pre]
 
Good day r_2


I have turned your data into a table and filtered as you say you need, take a look at the file in my Dropbox to see if this is what you want, I have left the filter on in the stock in date.


https://dl.dropbox.com/u/75495784/FilteronStockinDate.xls
 
not sure how you want the data/result, but if you just want to view those specific records, i would select the cells with the field names and enable filtering. then you can go to the Stock In Date field and set the desired filter.


if you want specific rows that meet this date range somewhere else, then you could use the advanced fitler that you first mention in your title.


copy the field name that you have 'requirments/criteria' for (Stock in date) and then paste the label somewhere (different part of the sheet or on a new sheet) [you can simply type the field name but copy/paste is much safer as they must match exactly].


then below this new cell type

>12/06/2012

<1/11/13


it should look like this:


Stock in Date

>12/06/2012

<1/11/13


then go to the advanced filter.

select 'copy results' and select whichever cell you want your results to show up.

list range will be the cells where all your data is (the table you provided above)

criteria range will be the cells that we just setup containing the field name and the date range.


if all is setup properly, just hit ok and the filter should only copy the resulting records that meet the provided criteria.


let me know that does or doesnt work
 
Hi, thanx...but can u provide a sample of advance filter as u decribed in the later part with my inputs whiout changing the date format...I try the way you describe. but unable to get the result. thanx
 
Hi ,


If you don't mind doing it manually , try the following :


With the filter on , in the Stock in date column , click on the filter drop-down arrow.


Click on Date Filters


Select Between


Select is after or equal to


Using the Date Picker , select your start date of 6th December


Click on And


Select is before or equal to


Using the Date Picker , select your end date of 11th January


Narayan
 
You must log in or register to reply here.
Back
Top