Reduce a list of dates

[London123]

Hi,


I have a list of participant ID's and start and stop dates for when they have been on a medication. Some participants have multiple rows but I would like one row per participant.


Participant Start date Stop date
1 24.11.2011 01.01.2016
1 18.02.2010 24.11.2011
1 24.11.2011 01.01.2016
1 18.02.2010 24.11.2011




I would like to just take the earliest date for the start date and the latest date for this stop date.


Participant Start date Stop date
1 18.02.2010 01.01.2016




Any help would be greatly appreciated!


Thank you

 

[Delfinus25]

Hi,


I have a list of participant ID's and start and stop dates for when they have been on a medication. Some participants have multiple rows but I would like one row per participant.


Participant Start date Stop date
1 24.11.2011 01.01.2016
1 18.02.2010 24.11.2011
1 24.11.2011 01.01.2016
1 18.02.2010 24.11.2011




I would like to just take the earliest date for the start date and the latest date for this stop date.


Participant Start date Stop date
1 18.02.2010 01.01.2016




Any help would be greatly appreciated!


Thank you

Excel stores dates as numerical values, which increase with each day. You should be able to use a MIN and MAX function to find the first and last date in the list.

 

[London123]

Excel stores dates as numerical values, which increase with each day. You should be able to use a MIN and MAX function to find the first and last date in the list.

OK thanks. I didn't mention that the list is very long, it has over 3000 rows (and about 1000 participants). I am not sure how I would get excel to give the min/ max function for each participant ID?

 

[Joe4]

We had a very similar thread to this earlier. You should be able to use the same options.
See: https://www.mrexcel.com/forum/excel-questions/1000199-combine-data-different-rows.html