Random selection

[norm01]

I have 10 employees and need to randomly schedule them for fairness in schedule
they are numbered 1 to 10
when I use RANDBETWEEN I get duplicates
is there a way I can stop the duplicates and have 1 to 10 in random order going down a column?

[norm01]

is RANDBETWEEN not the way to go?
is there another way?

[AndyLitch]

here's one method using a macro

Please Login or Register  to view this content.

[sktneer]

Try this.......

Please Login or Register  to view this content.

For detail see the attached sheet.

[AZ-XL]

Hi
Start this array formula from second row. and drag down
=LARGE(IF(COUNTIF($A$1:A1,ROW($1:$10)),0,ROW($1:$10)),RANDBETWEEN(1,SUM(--(IF(COUNTIF($A$1:A1,ROW($1:$10)),0,ROW($1:$10))>0))))

Ctrl+Shift + Enter