| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a large list by date (month number)
Hello All,
I have a list of 13,000 call records imported into Excel 2000. I have added an extra column so I can convert the call dates into months (1-12) using the month function. Is there an easier way to convert all the call date records apart from dragging the formula across all 13,000 records? Appreciate any help. Mac |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting a large list by date (month number)
Mac
If the column with the =MONTH formula is adjacent to the dates column just double-click on the fill handle of the top formula cell. This will copy/increment the formula all the way down. OR enter the formula in top cell of helper column then enter B1:B13000 and ENTER. Where B is your helper column. CTRL + d to copy down. Gord Dibben MS Excel MVP On Tue, 9 Jan 2007 06:28:01 -0800, Mac1 wrote: Hello All, I have a list of 13,000 call records imported into Excel 2000. I have added an extra column so I can convert the call dates into months (1-12) using the month function. Is there an easier way to convert all the call date records apart from dragging the formula across all 13,000 records? Appreciate any help. Mac |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting a large list by date (month number)
Thanks Gord. Worked out fine.
Mac "Gord Dibben" wrote: Mac If the column with the =MONTH formula is adjacent to the dates column just double-click on the fill handle of the top formula cell. This will copy/increment the formula all the way down. OR enter the formula in top cell of helper column then enter B1:B13000 and ENTER. Where B is your helper column. CTRL + d to copy down. Gord Dibben MS Excel MVP On Tue, 9 Jan 2007 06:28:01 -0800, Mac1 wrote: Hello All, I have a list of 13,000 call records imported into Excel 2000. I have added an extra column so I can convert the call dates into months (1-12) using the month function. Is there an easier way to convert all the call date records apart from dragging the formula across all 13,000 records? Appreciate any help. Mac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Month End Projection formula? | Excel Worksheet Functions | |||
| Fomula for number of days on each month from a date range | Excel Discussion (Misc queries) | |||
| Counting the number of date entries in a giving month | Excel Discussion (Misc queries) | |||
| Current date formula based on month | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Linear Mode
