Latest Enterprise DNA Initiatives

1 for first occurrence else 0

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.

ProblemUniqueOppty.xlsx (15.4 KB)

Hi @KimC,

Give something like this a go.

Your file:
ProblemUniqueOppty.xlsx (15.6 KB)

I hope this is helpful


Thank you so much Melissa :pray: