dimanche 30 décembre 2018

Randonly select numbers from a range of cells i have 8 numbers and i want to randonly select 7 in different cells

I have data in cells J3:R3

I want to randomly select 7 of them and put them into a table B2:H18 where in B2:H2 there are no duplicates.

=INDEX($J$3:$R$3,RANDBETWEEN(1,7)) this works but cant handle duplicates =CHOOSE(RANDBETWEEN(1,7),J$3:R$3) this didn't work




Aucun commentaire:

Enregistrer un commentaire