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

4 Likes

Thank you so much Melissa :pray: