mardi 16 août 2022

Select random cell from non-adjacent cells/columns

I got multiple columns with information. I want to pick a random sentence from 'Mehrzahl' for every row involved. Is it possible to do this with a formula? In the case of Mehrzahl I want to select either E2 or N2 randomly, either E3 or N3 randomly, et cetera.

Example file




Aucun commentaire:

Enregistrer un commentaire