Hi,
I have this case where I have two similar columns together but I need to randomize the two columns but avoiding matchings.
Let's say that at the moment we randomize the two columns, the idea is not to have in a same row A:A or F:F.......
Can you explain a bit more on the use case? maybe this weekly challenge can give you some inspiration:
https://community.alteryx.com/t5/Weekly-Challenge/Challenge-247-Pairing-Partners/td-p/683230
Just went down a bit of a rabbit hole with this one but quite fancied the challenge and iterative macro practice. There's probably a way more succinct version but this will create a truly random order with no matches. You'll just need to map your two comparison fields when you plug your data into the macro @bersocha:
Before:
After:
Edit: Currently troubleshooting as it doesn't work consistently!
Edit 2: Fixed!