Hello Everyone!
Following the old post (Rand Between Multiple Lists With No Duplicates).
Is it possible to make it for two lines at the bottom?
We generate the names on the line 20. How can I create a new sort in line 21 without duplicating the names of the same column in line 20 and not duplicating the names of the line 21?
Example: If "Cat" is in B20, how can i keep it from beeing "Cat" again in B21 and also not duplicate "Cat" in line 21?
I'm using this:
Following the old post (Rand Between Multiple Lists With No Duplicates).
Is it possible to make it for two lines at the bottom?
We generate the names on the line 20. How can I create a new sort in line 21 without duplicating the names of the same column in line 20 and not duplicating the names of the line 21?
Example: If "Cat" is in B20, how can i keep it from beeing "Cat" again in B21 and also not duplicate "Cat" in line 21?
I'm using this:
Range | Formula | |
---|---|---|
Cell Formulas | ||
A20 | A20 | =IFERROR(INDEX(A$3:A$17,RANDBETWEEN(1,COUNTA(A$3:A$17)),1),"") |
B20:D20 | B20 | =IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW(B$3:B$17)/(COUNTIF($A20:A20;B$3:B$17)=0)/(B$3:B$17<>""),RANDBETWEEN(1,SUMPRODUCT(--(B$3:B$17<>""),--(COUNTIF($A20:A20;B$3:B$17)=0))))),"") |