| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Custom Filter
I have a worksheet which have Sales Record for the whole year. I tried to
filter for particular month according to date which is in column A from 01.04.06 to 31.12.2007. I just want to filter data for the month of April, 06 than how i should use data filter custom so that its reults come what i want. Regards RRS |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Custom Filter
Assuming the dates in your date column are real dates,
and your regional short date format is: M/d/yyyy Autofiltering on the date column .. Click Data Filter Autofilter Custom then make the settings under "Show rows where": is greater than or equal to : 4/1/2006 And is less than: 5/1/2006 Click OK The above should filter out "data for the month of April, 06" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Rao Ratan Singh" wrote: I have a worksheet which have Sales Record for the whole year. I tried to filter for particular month according to date which is in column A from 01.04.06 to 31.12.2007. I just want to filter data for the month of April, 06 than how i should use data filter custom so that its reults come what i want. Regards RRS |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Thank you Max
Thank you very much Max. You solved my problems several times. Thank you once
again. yours RRS "Max" wrote: Assuming the dates in your date column are real dates, and your regional short date format is: M/d/yyyy Autofiltering on the date column .. Click Data Filter Autofilter Custom then make the settings under "Show rows where": is greater than or equal to : 4/1/2006 And is less than: 5/1/2006 Click OK The above should filter out "data for the month of April, 06" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Rao Ratan Singh" wrote: I have a worksheet which have Sales Record for the whole year. I tried to filter for particular month according to date which is in column A from 01.04.06 to 31.12.2007. I just want to filter data for the month of April, 06 than how i should use data filter custom so that its reults come what i want. Regards RRS |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Thank you Max
"Rao Ratan Singh" wrote:
Thank you very much Max. You solved my problems several times. Thank you once again. You're welcome, Rao ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to add an additional option in CUSTOM FILTER | Excel Discussion (Misc queries) | |||
| Custom Filter not functioning | Excel Discussion (Misc queries) | |||
| Cell reference in the auto filter custom list | Excel Discussion (Misc queries) | |||
| custom filter does not work correctly | Excel Discussion (Misc queries) | |||
| Custom Filter Problem | Excel Discussion (Misc queries) | |||
Linear Mode
