Formaula Help

[agimpel]

 I have controls that will each have 3 separate tests associated with them. One of the tests is a Test of Design that is easily identifiable by the name within the control "Test" column. I then will have 2 "control test" labels for each control. I want to create a new column that will label the control tests either test 1 or 2 based on the date of the test (the earlier test will be test 1 and the later will be 2). The test of design is self explanatory as it is already labeled accordingly. Could you please provide some assistance on how to get to my desired outcome column given the 3 example columns? I believe I will also have to change the "test date" format. See attached for my example data: 

[binuacs · Accepted solution]

@agimpel one way of doing this with tile tool

[Qiu · Accepted solution]

@agimpel 
We can also use a Multi-Row Formula tool to do this as below.

And there is a macro "CReW Grouped Record ID" can also assign the SN.

https://marketplace.alteryx.com/en-US/apps/420292/crew-grouped-record-id