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

Thank you for your response, it was helpful.

I wanted to extend this further, please find attached the sample scenario and similar sort of number sequencing is required.

Thanks & regards,
Snehith

Thanks a lot. This one worked.

Regards,
Snehith

Hi,

It appears that the formula is not working in all scenarios. One quick example, the countifs function does a count including the row where the output is displayed, as a result of this in some instances I'm getting one number more in the sequence generated. Could someone please help me on this.

Thanks & regards,
Snehith