Reduce list of dates by selecting earliest and latest date

  • 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!


    https://www.mrexcel.com/forum/…82-reduce-list-dates.html


    https://www.excelforum.com/exc…duce-a-list-of-dates.html


    Thank you

  • Re: Reduce list of dates by selecting earliest and latest date


    All the participants in the attached are unique.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Re: Reduce list of dates by selecting earliest and latest date


    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    *

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!