I want to select two items randomly from a (shortish) list with no duplicates.
To select one item I used
=INDEX(B$18:B$29,RANDBETWEEN(1,COUNTA(B$18:B$29)))
but when I copy this down to get a second value, as the list is relatively short, I get duplicates.
I tried using IF but couldn't see a way to get the second value to recalculate until it was unique. So I tried UNIQUE too, but still couldn't find a solution.
Anyone, please.
To select one item I used
=INDEX(B$18:B$29,RANDBETWEEN(1,COUNTA(B$18:B$29)))
but when I copy this down to get a second value, as the list is relatively short, I get duplicates.
I tried using IF but couldn't see a way to get the second value to recalculate until it was unique. So I tried UNIQUE too, but still couldn't find a solution.
Anyone, please.