| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
I have the Target date against each activity in one column which spreads through out the year. How can i filter all the activities related to a specific month. I should not add any column. Target Date 01-Oct-06 28-Oct-06 03-Nov-06 01-Jan-06 01-Jan-06 03-Oct-06 01-Jun-06 01-Oct-06 03-Oct-06 Thanks for your help in advance. J Kannan Larsen & Toubro Chennai, India |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtering
www.rondebruin.nl/easyfilter.htm
Jaleel "J kannan" wrote: I have the Target date against each activity in one column which spreads through out the year. How can i filter all the activities related to a specific month. I should not add any column. Target Date 01-Oct-06 28-Oct-06 03-Nov-06 01-Jan-06 01-Jan-06 03-Oct-06 01-Jun-06 01-Oct-06 03-Oct-06 Thanks for your help in advance. J Kannan Larsen & Toubro Chennai, India |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtering
highlight the sort area - click on Data in the menu bar - then click Sort -
click the Options button and create your own sort rules.. it works in Office2000 - don't know about later versions.. "J kannan" wrote: I have the Target date against each activity in one column which spreads through out the year. How can i filter all the activities related to a specific month. I should not add any column. Target Date 01-Oct-06 28-Oct-06 03-Nov-06 01-Jan-06 01-Jan-06 03-Oct-06 01-Jun-06 01-Oct-06 03-Oct-06 Thanks for your help in advance. J Kannan Larsen & Toubro Chennai, India |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another Filtering Question for Excel 2007 Experts | New Users to Excel | |||
| Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
| avanced filtering for latest date | Excel Discussion (Misc queries) | |||
| Using Filtering | Excel Discussion (Misc queries) | |||
Linear Mode
