Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
advanced filtering
i am using advanced filtering to filter a list. i am
filtering it in place. it is a 15 column table with headings, so rows 1 and 2 are exactly the same as rows 3 and 4 respectively. one of the columns is a date column. can someone tell me what i would enter in the criteria range to filter the list for all entries made in the month of january? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
advanced filtering
Spence,
so rows 1 and 2 are exactly the same as rows 3 and 4 respectively. What you mean by this? anyway if your dates are in colA, A1 is header, and dates starts in A2 put this formula in a cell of a blank column with some empty cells above it. =MONTH(A2)=1 select this cell and the empty cell above as the criteria. HTH Cecil "spence" wrote in message ... i am using advanced filtering to filter a list. i am filtering it in place. it is a 15 column table with headings, so rows 1 and 2 are exactly the same as rows 3 and 4 respectively. one of the columns is a date column. can someone tell me what i would enter in the criteria range to filter the list for all entries made in the month of january? TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
advanced filtering
Easy
he month of the date column using "=MONTH(date col)" and then use Autofilter to select all Months=1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filtering | Excel Discussion (Misc queries) | |||
advanced filtering | Excel Discussion (Misc queries) | |||
advanced filtering | Excel Worksheet Functions | |||
advanced filtering in XLS | Excel Worksheet Functions | |||
Advanced Filtering in VBA | Excel Programming |