May I know how can I randomly select one value from a single cell with comma separator?
Input Value
Expected Output
I appreciate your help on this.
Thanks!
Solved! Go to Solution.
Hi @jayross0117 ,
randint() can generate 0 to n random nums .
I changed random formula to : RandInt([Max_Tile_SequenceNum] -1 ) +1
Thanks @benakesh. That's a cool solution. I tried it and it worked. However, I just have a quick question. My cell values can have a different number of rows after using text to columns. A single cell can have a 3 rows, the another cell can have 2 rows. How can I run the workflow dynamically when they have different no. of rows also? Thanks!
Hi @jayross0117 ,
I revised original post and replaced attached workflow .
Thank you so much @benakesh!!! That works!