| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort Using Date Functions
Is there a way to use the date functions on the Key
parameter of the SORT method? Instead of trying to have the user type the date in YYYY/MM/DD, I wanted to the Year and Month fucntions on the column range in order to sort by Year and Month. Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sort Using Date Functions
No. You would need to set up dummy columns.
-- Regards, Tom Ogilvy "Dean" wrote in message ... Is there a way to use the date functions on the Key parameter of the SORT method? Instead of trying to have the user type the date in YYYY/MM/DD, I wanted to the Year and Month fucntions on the column range in order to sort by Year and Month. Is this possible? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sort Using Date Functions
Hi
you could use a helper column with a formula like =TEXT(A1,"YYYYMM") and sort with this column -- Regards Frank Kabel Frankfurt, Germany Dean wrote: Is there a way to use the date functions on the Key parameter of the SORT method? Instead of trying to have the user type the date in YYYY/MM/DD, I wanted to the Year and Month fucntions on the column range in order to sort by Year and Month. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort and Filter functions returnng different results | Excel Discussion (Misc queries) | |||
| Sort with IF functions? | Excel Discussion (Misc queries) | |||
| Date Functions | Excel Discussion (Misc queries) | |||
| the date format is not working ,sort by date doesn't work. | Excel Discussion (Misc queries) | |||
| Automatic Sort with VLOOKUP/LARGE Functions | Excel Worksheet Functions | |||
![Dean[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
