J
J. Gutierrez
I am working on a cancer research database in Excel, and have been told that
the following can only be done in Access, so here goes...
(simplified example of what I have now in Excel)
A B
1 Patient ID Date of Diagnosis
2 00001 10/1/1997
3 00001 10/1/1998
4 00002 09/1/2002
5 00002 09/1/2003
6 00003 09/1/2005
Each time a patient (uniquely and systematically identified by their own
patient ID) presents with a new cancer/tumor, they have a separate record
(row) in my excel spreadsheet with the corresponding Date of Diagnosis in
addition to other data. I want to calculate the time between these dates
(presently on different rows), and perhaps create a new spreadsheet with each
patient ID listed only ONCE, with "columns" such as "time from 1st diagnosis
to 2nd", "time from 2nd diagnosis to third", etc.
Can anybody help?
Thanks a bunch,
JG
the following can only be done in Access, so here goes...
(simplified example of what I have now in Excel)
A B
1 Patient ID Date of Diagnosis
2 00001 10/1/1997
3 00001 10/1/1998
4 00002 09/1/2002
5 00002 09/1/2003
6 00003 09/1/2005
Each time a patient (uniquely and systematically identified by their own
patient ID) presents with a new cancer/tumor, they have a separate record
(row) in my excel spreadsheet with the corresponding Date of Diagnosis in
addition to other data. I want to calculate the time between these dates
(presently on different rows), and perhaps create a new spreadsheet with each
patient ID listed only ONCE, with "columns" such as "time from 1st diagnosis
to 2nd", "time from 2nd diagnosis to third", etc.
Can anybody help?
Thanks a bunch,
JG