Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA❤️
Best Regards
Arundhuti
I was able to do this essentially with the Summarize tool, but I was looking for something else initially: It would be great to have a function that works like an on/off switch, as in: "if I encounter this value then 'on' (eg '1'), if I encounter it again then 'off' (or 0)" (This principle could repeat)
Surprisingly, I couldn't find such!
I didn't read the question on the forum, just in the workflow and so made my answer to work if an ID was to appear >2 times. Little iterative macro..
And the Macro:
Two approaches:
Way happier with the first approach though.