| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter by year
Hello,
I have a column of dates, and wish to filter them by year. I tried an auto filter and did a custome filter of (ends in *2007) this didn't work. Any ideas? 1/11/2007 16/3/2007 25/5/2007 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter by year
Somewhere to the right of your date column, create a Year column and use the
following formula to extract the year from your dates, substituing cell A2 for the starting cell of your date column: =YEAR(A2) Copy down as far as necessary and use the year column as your filter column -- Kevin Backmann "Nightshade" wrote: Hello, I have a column of dates, and wish to filter them by year. I tried an auto filter and did a custome filter of (ends in *2007) this didn't work. Any ideas? 1/11/2007 16/3/2007 25/5/2007 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter by year
One way would be to use a helper column and pull out the year with something
like =YEAR(A2), copied down.........then filter on that column. Vaya con Dios, Chuck, CABGx3 "Nightshade" wrote: Hello, I have a column of dates, and wish to filter them by year. I tried an auto filter and did a custome filter of (ends in *2007) this didn't work. Any ideas? 1/11/2007 16/3/2007 25/5/2007 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter by year
try
Customgreater or = 39083 AND less than 39448 -- Don Guillett Microsoft MVP Excel SalesAid Software "Nightshade" wrote in message ... Hello, I have a column of dates, and wish to filter them by year. I tried an auto filter and did a custome filter of (ends in *2007) this didn't work. Any ideas? 1/11/2007 16/3/2007 25/5/2007 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter by year
Another would be to convert the date-number to a TEXT value, with this
formula copied down a helper column, then you could do your "ends with" thing =TEXT(A2,"dd/mm/yyyy") Vaya con Dios, Chuck, CABgx3 "CLR" wrote: One way would be to use a helper column and pull out the year with something like =YEAR(A2), copied down.........then filter on that column. Vaya con Dios, Chuck, CABGx3 "Nightshade" wrote: Hello, I have a column of dates, and wish to filter them by year. I tried an auto filter and did a custome filter of (ends in *2007) this didn't work. Any ideas? 1/11/2007 16/3/2007 25/5/2007 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter by year
Hi Nightshade
See also this add-in No need for a helper column http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Nightshade" wrote in message ... Hello, I have a column of dates, and wish to filter them by year. I tried an auto filter and did a custome filter of (ends in *2007) this didn't work. Any ideas? 1/11/2007 16/3/2007 25/5/2007 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| how to calculate $1000/year at 5% for 25 years showing each year | Setting up and Configuration of Excel | |||
| Months auto-filter with year twist | New Users to Excel | |||
| filter companies that does not perform a year | Excel Discussion (Misc queries) | |||
| How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
Linear Mode
