If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Entering date in a cell so that it falls in specific way when sorted?
I have an entry that I know falls in February 2004 but that we don't
have an exact date for as that information has been lost (ahem, _not_ may I say by me [thank goodness!] lol). Anyway, all the other entries for this date column are in the usu. m/d/yyyy format even though they have a custom setting that has it display differently. My problem is one I've run into many times before - how to have a, say, 2004.02 entry (for Feb.2004) sort between the last January 2004 one and the first February 2004 one? Is it possible to enter the Feb.2004 date in such a way that it will sort "properly"?? Thank you! |
#2
|
|||
|
|||
Entering date in a cell so that it falls in specific way when sorted?
Hi
the only idea I have: - first enter this date as 2/1/2004 - use a helper column to tag these entries (e.g. insert a 'X' for these records in this helper column) Now sort using both columns -- Regards Frank Kabel Frankfurt, Germany Jones wrote: I have an entry that I know falls in February 2004 but that we don't have an exact date for as that information has been lost (ahem, _not_ may I say by me [thank goodness!] lol). Anyway, all the other entries for this date column are in the usu. m/d/yyyy format even though they have a custom setting that has it display differently. My problem is one I've run into many times before - how to have a, say, 2004.02 entry (for Feb.2004) sort between the last January 2004 one and the first February 2004 one? Is it possible to enter the Feb.2004 date in such a way that it will sort "properly"?? Thank you! |
#3
|
|||
|
|||
Entering date in a cell so that it falls in specific way when sorted?
Frank, you are simpy one of the best !
"Frank Kabel" schrieb im Newsbeitrag ... Hi the only idea I have: - first enter this date as 2/1/2004 - use a helper column to tag these entries (e.g. insert a 'X' for these records in this helper column) Now sort using both columns -- Regards Frank Kabel Frankfurt, Germany Jones wrote: I have an entry that I know falls in February 2004 but that we don't have an exact date for as that information has been lost (ahem, _not_ may I say by me [thank goodness!] lol). Anyway, all the other entries for this date column are in the usu. m/d/yyyy format even though they have a custom setting that has it display differently. My problem is one I've run into many times before - how to have a, say, 2004.02 entry (for Feb.2004) sort between the last January 2004 one and the first February 2004 one? Is it possible to enter the Feb.2004 date in such a way that it will sort "properly"?? Thank you! |
#4
|
|||
|
|||
Entering date in a cell so that it falls in specific way when sorted?
"Frank Kabel" wrote in message ...
Hi the only idea I have: - first enter this date as 2/1/2004 - use a helper column to tag these entries (e.g. insert a 'X' for these records in this helper column) Now sort using both columns -- Regards Frank Kabel Frankfurt, Germany Frank, thank you for your response. I wanted to do this without adding an extra column to fiddle with. I needed to do something to the text entered in the date so that it just automatically sorted properly so this idea wouldn't actually work. However, your response triggered something that _will_ do the job; so after all these years I've ever had this problem, thank you so much for inadvertently leading me to an almost perfect solution! g D'UH!! I'll enter the date as 2/1/2004, as you say, but I'll CHANGE THE DISPLAY from "yyyy.mm.dd.ddd" to something like "Feb.2004"!!! That will be awesome! Other users will in all likelihood never notice this but I'll probably just add a comment in that cell in case they ever wonder and want to change things. (But probably they'll never notice or care.) So it'll sort after the January 2004 entries but will appear before the first February entry which happens to occur around the 14th! Awesome! I should have mentioned that I might be creating all these files, but I'm just a temporary contractor so they're going to be left behind for others to use. So I have to keep it very, very simple. I have a dozen such log sheets and to have just this sheet have an extra column just so it would sort ONE entry "properly" would not be a viable solution whereas changing the display manually myself for this one instance is. Thank you so much! g I really appreciate the help; it doesn't matter how a solution is found as long as the problem is solved! lol Jones wrote: I have an entry that I know falls in February 2004 but that we don't have an exact date for as that information has been lost (ahem, _not_ may I say by me [thank goodness!] lol). Anyway, all the other entries for this date column are in the usu. m/d/yyyy format even though they have a custom setting that has it display differently. My problem is one I've run into many times before - how to have a, say, 2004.02 entry (for Feb.2004) sort between the last January 2004 one and the first February 2004 one? Is it possible to enter the Feb.2004 date in such a way that it will sort "properly"?? Thank you! |
Thread Tools | |
Display Modes | |
|
|