Unique Random Name

[alamgiritbd]

Hi,


I try to get unique name from a list. the list is in A2:A10. and i want to get data in B2:B10. I try this: =INDEX($A2:$A10,RANDBETWEEN(1,COUNTA($A2:$A10)),1) on B2:B10.


But the problem is it's take duplicate data from the list/range. i need each cell get unique random data from the list.

 

[keymaster]

You are essentially trying to shuffle the list in A2:A10. Read this : http://chandoo.org/wp/2008/07/28/shuffle-cells-random-order/


See this for a formula based technique : http://chandoo.org/wp/2008/09/23/sort-in-random-order-excel-formulas/

 

[alamgiritbd]

Hello Chandoo,


Thank..s.:-