Adding column with assigned value based on dates|Power Query|Excel Forum|My Online Training Hub

Hi Mynda,

First time post here, so hopefully this is clear - I have attached a dummy file of just a few example columns to get my point across.

Essentially, I have duplicate IDs in a file and each has two different assessments dates (pre and post) and associated scores. How can I create a column that assigns a '1' for the first assessment date in a duplicate pair and '2' for the second assessment date in a duplicate pair? The goal here is just to do some quick and dirty analyses of aggregate pre scores for all and post scores for all and look at change by each subscale score.

Thanks for your help!

-Adrienne