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