jeudi 28 octobre 2021

Excel random value from a string containing substrings

I have this table that is defined as "Table1".

enter image description here

I also have a string which contains substrings inside it with delimiter ", " (comma + space)

I would like to get a formula to get one of those substrings randomly.

Excel version: Excel 365

Thanks in advance.




Aucun commentaire:

Enregistrer un commentaire