Hi, I am comparing some questionnaire responses (baseline, 3 month follow-up, 6 month follow-up). I have a full list of all entries with dates when the questionnaire was administered, but I need to identify which entries were baseline (1), 3 month follow-up (2) or 6 month follow-up (3), so that I can calculate average before and after scores. Essentially, I want to produce the 'Date sequence' column which I have highlighted. I assigned '1', '2', '3' manually, but as there are hundreds of unique IDs, I want a formula to complete the rest.

Thanks!

Attached Images

Untitled.png (18.1 KB, 19 views)

Will all identical ID's be grouped?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yes, eventually I would have a table: ID | 1st score | 2nd score | 3rd score

It would be helpful if you attached an actual worksheet with some representative data, rather than just an image. That way, no-one has to re-type everything and you could supply a larger sample.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]