Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to sort by date this way?
If I have a list which contains a date, but that date isn't at the beginning
of the line, so when sorting, the list can only be sorted A-Z. Any way to make it recognize the dates? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to sort by date this way?
Hi,
It would have helped to see your data layout but you may be able to extract the dates to a helper column and sort using that. =MID(A1,11,9)*1 Would extract a 9 character date start at position 11 in A1. You would have to format this as a date. Mike "jmj713" wrote: If I have a list which contains a date, but that date isn't at the beginning of the line, so when sorting, the list can only be sorted A-Z. Any way to make it recognize the dates? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to sort by date this way?
Sorry, I should've specified. I have only a year listed, so most of the look
like this: XXXXXXXX (1993) etc. The formula you provided results in an error, perhaps it needs adjustment for the four-digit year. "Mike H" wrote: Hi, It would have helped to see your data layout but you may be able to extract the dates to a helper column and sort using that. =MID(A1,11,9)*1 Would extract a 9 character date start at position 11 in A1. You would have to format this as a date. Mike "jmj713" wrote: If I have a list which contains a date, but that date isn't at the beginning of the line, so when sorting, the list can only be sorted A-Z. Any way to make it recognize the dates? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to sort by date this way?
Sorry, I should've specified. I have only a year listed, so most of the look
like this: XXXXXXXX (1993) etc. The formula you provided results in an error, perhaps it needs adjustment for the four-digit year. "Mike H" wrote: Hi, It would have helped to see your data layout but you may be able to extract the dates to a helper column and sort using that. =MID(A1,11,9)*1 Would extract a 9 character date start at position 11 in A1. You would have to format this as a date. Mike "jmj713" wrote: If I have a list which contains a date, but that date isn't at the beginning of the line, so when sorting, the list can only be sorted A-Z. Any way to make it recognize the dates? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort date | Excel Discussion (Misc queries) | |||
sort on a date | Excel Discussion (Misc queries) | |||
sort by date | Excel Discussion (Misc queries) | |||
the date format is not working ,sort by date doesn't work. | Excel Discussion (Misc queries) | |||
Can't sort by date | New Users to Excel |