Hi,
I new to this and therefore somewhat lacking in know-how, basically I have a spreadsheet which has Random numbers between 1-125 with no duplicates in column A =LARGE(ROW($1:$125)*NOT(COUNTIF($A$1:A1, ROW($1:$125))), RANDBETWEEN(1,126-ROW(A1)))
I then have a list of 125 songs in column B
I want to randomly select 16 out of the 125 songs for a bingo style game (i need to be able to randomly select 16 songs over & over again for Bingo Cards)
so in column C, I select 16 random numbers (from the range 1-125) =INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1
what I then want is for the corresponding songs to appear in column D, For example: I shuffle my 125 numbers in column A using F9, This gives each song in column B a completely random number. I then randomly select 16 of the possible 125 numbers in column C, I then want column D cell 1 to look at the numbers in column C cell 1 and match it with whichever cell on column A has the same number (eg: A52) then copy the corresponding song (which would therefore be adjacent to the cell containing the relevant number) and then place that song into a list of 16 songs in column D) Then repeat this over & over generating a random short list of 16 songs out of the 125 each time.?????
Now I just need to know how on earth I do this? Help greatly appreciated.
Bookmarks