R
Robert Judge
I have an EXCEL 2003 worksheet with four columns and about one thousand rows
containg this sample data:
NAME BIRTHDATE ANNIVERSARY DEATH DATE
John Smith June 1, 1920 July 15, 1940 August 1, 1980
Mary Jones January 1, 1930 September 15, 1955 October 1, 1995
I would like to create a worksheet that would sort all of the information by
date. For instance, the worksheet would display the above data in one column
like this:
June 1, 1920 John Smith Birthdate
January 1, 1930 Mary Jones Birthdate
July 15, 1940 John Smith Anniversary
September 15, 1955 Mary Jones Anniversary
August 1, 1980 John Smith Death Date
October 1, 1995 Mary Jones Death Date
This may be impossible, of course, but I thought I would ask just in case
anyone has an idea. I will appreciate advice.
containg this sample data:
NAME BIRTHDATE ANNIVERSARY DEATH DATE
John Smith June 1, 1920 July 15, 1940 August 1, 1980
Mary Jones January 1, 1930 September 15, 1955 October 1, 1995
I would like to create a worksheet that would sort all of the information by
date. For instance, the worksheet would display the above data in one column
like this:
June 1, 1920 John Smith Birthdate
January 1, 1930 Mary Jones Birthdate
July 15, 1940 John Smith Anniversary
September 15, 1955 Mary Jones Anniversary
August 1, 1980 John Smith Death Date
October 1, 1995 Mary Jones Death Date
This may be impossible, of course, but I thought I would ask just in case
anyone has an idea. I will appreciate advice.