Order of appearance of a set of values

[#1]

Hello,

I'm looking for a JMP built-in function that I'm pretty sure it exists but I could not find.

It helped you create a new column in a datable that will affect to each row the order of appearance of a set of columns. For example, in this table, I want to count the order of appeareace of each set of values {col1, col2} :

It should give me a third column like this :

Maybe I'm wrong, but if any of you can remember a function like this one, it will help me. Thank you !

[#2 · Accepted solution]

Col Cumulative Sum(1, byvars) should work

Col Cumulative Sum(1, :Column 1, :Column 2)

Col Rank is another option which might work

[#3]

Well thank you, I did find this one but had struggle using it, it works well now !

Have a great day