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