Randomly select value from a single cell with comma

[jayross0117]

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!

[benakesh · Accepted solution]

Hi @jayross0117 ,

randint()  can  generate  0  to n  random nums   .

I changed  random formula to  :  RandInt([Max_Tile_SequenceNum] -1 ) +1

[jayross0117]

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!

[benakesh]

Hi @jayross0117 ,

I revised original post and  replaced  attached workflow .

[jayross0117]

Thank you so much @benakesh!!! That works!