| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter by month & year when I have a column full of dates ??
Hi GTolhurst
You can use EasyFilter to do this http://www.rondebruin.nl/easyfilter.htm Or add a helper column in your data that test the month and year -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "GTolhurst" wrote in message ... I have a c0lumn full of various dates (24/03/2007) over the last 5 years, I need to be able to autofilter by month and year ?? I thought I could use a group function but it isnt working ?? Any ideas please ?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate month & year in between two dates | Excel Worksheet Functions | |||
| Calculate month & year in between two dates | Excel Worksheet Functions | |||
| Sorting dates by month instead of year | Excel Worksheet Functions | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
| sort dates by month and day not year | Excel Worksheet Functions | |||
Threaded Mode
