To generate a number sequence based on criteria from different columns

Hi friends,

Please help me out in generating a formula to derive a number sequence.

For the set of data attached here, for every identifier I need a number pattern to be generated as the output, based on the columns C,D,E,F,G,H,I and J, also the sequencing should start from the beginning for every assessment.

In the example here, for Assessment1 even though row3 and row4 identifiers are the same but the individual constituents are different (for row3-P4="Y", whereas for row4-P4="G"), similarly for Assessment2 row9 and row11 have same identifiers and also the same constituents and hence the same sequence for both.

Kindly help me on this.

Thanks & regards
Snehith