Hi,
I was trying to figure out how to randomly select name from list; I tried with RANDBETWEEN() but didn't get the desired result.
I have a list of unique names in a column and I want to assign one name each from the same list without any duplicates.
Example:
Col A
a
b
c
d
e
f
I want a formula to randomly select name from the list and assign to each cell without duplicates and if 'd' is assigned to 'a', then 'a' has to been assigned to 'd', not other name from list.
Result:
Col A Col B a d b e c f d a e b f c
Kindly help me on this.
Thanks in advance and all your help will be much appreciated.
Pradeep
Bookmarks