| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create date
Hi,
column A contains the word Jan or Feb, or... column B contains a year how can I combine them into a date which I can sort chronologically? A B C DEC 1998 should become e.g. Dec-98 DEC 1998 JAN 1997 JAN 1997 FEB 1997 MAR 1997 APR 1997 APR 1997 MAY 1997 Thanks! tom |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create date
One way ..
Assuming data in cols A & B in row2 down Put in say, C2: =DATEVALUE(A2&B2) Format C2 as Custom, type: mmm-yy Copy C2 down We can now sort cols A to C by col C .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "tom ossieur" wrote: column A contains the word Jan or Feb, or... column B contains a year how can I combine them into a date which I can sort chronologically? A B C DEC 1998 should become e.g. Dec-98 DEC 1998 JAN 1997 JAN 1997 FEB 1997 MAR 1997 APR 1997 APR 1997 MAY 1997 Thanks! tom |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create date
Hi Tom,
In C1 put =(A1&"/"&B1)*1 and format C1 as custom mmm-yyyy HTH Martin |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create date
I can't get either of them to sort!
-- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Max" wrote in message ... One way .. Assuming data in cols A & B in row2 down Put in say, C2: =DATEVALUE(A2&B2) Format C2 as Custom, type: mmm-yy Copy C2 down We can now sort cols A to C by col C .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "tom ossieur" wrote: column A contains the word Jan or Feb, or... column B contains a year how can I combine them into a date which I can sort chronologically? A B C DEC 1998 should become e.g. Dec-98 DEC 1998 JAN 1997 JAN 1997 FEB 1997 MAR 1997 APR 1997 APR 1997 MAY 1997 Thanks! tom |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create date
I used Max's solution and I have to admit it works perfect.
just Data Sort "RagDyeR" wrote: I can't get either of them to sort! -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Max" wrote in message ... One way .. Assuming data in cols A & B in row2 down Put in say, C2: =DATEVALUE(A2&B2) Format C2 as Custom, type: mmm-yy Copy C2 down We can now sort cols A to C by col C .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "tom ossieur" wrote: column A contains the word Jan or Feb, or... column B contains a year how can I combine them into a date which I can sort chronologically? A B C DEC 1998 should become e.g. Dec-98 DEC 1998 JAN 1997 JAN 1997 FEB 1997 MAR 1997 APR 1997 APR 1997 MAY 1997 Thanks! tom |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create date
Stupid me ... tried to sort *only* the column of dates by itself, and forgot
the darned column is FORMULAS ! ! ! -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "tom ossieur" wrote in message ... I used Max's solution and I have to admit it works perfect. just Data Sort "RagDyeR" wrote: I can't get either of them to sort! -- Regards, RD -------------------------------------------------------------------------- -- ------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------------- -- ------------------- "Max" wrote in message ... One way .. Assuming data in cols A & B in row2 down Put in say, C2: =DATEVALUE(A2&B2) Format C2 as Custom, type: mmm-yy Copy C2 down We can now sort cols A to C by col C .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "tom ossieur" wrote: column A contains the word Jan or Feb, or... column B contains a year how can I combine them into a date which I can sort chronologically? A B C DEC 1998 should become e.g. Dec-98 DEC 1998 JAN 1997 JAN 1997 FEB 1997 MAR 1997 APR 1997 APR 1997 MAY 1997 Thanks! tom |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create date
"RagDyeR" wrote:
... tried to sort *only* the column of dates by itself, and forgot the darned column is FORMULAS ! ! ! That happens to me at times too, RD <g ! "tom ossieur" wrote in message ... I used Max's solution and I have to admit it works perfect. just Data Sort Glad it worked for you, Tom Thanks for feedback .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| How do I create an automatic date entry? | Excel Discussion (Misc queries) | |||
| Date format issue | New Users to Excel | |||
| how to create a new sheet with today's date | Excel Discussion (Misc queries) | |||
| Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
Linear Mode
