1 for first occurrence else 0

KimC · September 20, 2022, 9:26am

Hello M-Code super users,

I am trying to do a workaround with my file of 30,000 lines and I am wondering if this is possible with mcode:

I have a list of opportunity numbers, for the first occurrence of each unique number, I would like a 1 in a new column else 0.

Melissa · September 20, 2022, 4:10pm

Give something like this a go.

I hope this is helpful

KimC · September 26, 2022, 5:46am

Thank you so much Melissa