Jun 7, 2019 9:32 AM
| Last Modified: Jun 7, 2019 9:32 AM(1827 views)
Is there a way to easily select just the most recent time point for subjects with repeated measures? Some subjects have one time point, others have 15, and then there are others who are inbetween. The data are arranged so each timepoint has its own row with the data in the columns. There are subject numbers, dates, and which number iteration it is in the columns as well.
Thank you for the suggestion. I used the column maximum formula (Col Maximum (date, id)) to give the maximum date by ID. Then I was able to use the row selection function to find where the data column was equal to the maximum date.