Matrix Table - Sort machines

[alexoigres]

Hello everybody...
I need some help to automate one of my matrix tables... What I am looking for is to have a formula or a macro to mix randomly the list of machines that need to be audited by day.
My matrix has in column A the name of my 5 auditors and column AM is the list of my 80 machines that need to be audited. Column B, C, D, E….etc is the days of the month
Every month I have to manually change the machines from the table doing copy and paste so auditors do not have the same schedule.... each auditor needs to audit two machines per day (no weekends)
is there any easy way to do this?
Regards,
Alex

 

[alexoigres]

Any help on this? I have tried to find a template on internet but no successes ....thanks

 

[Confused_At_work]

If you are not concerned about some machines being missed in the month and some audited more than once, a simple =RANDBETWEEN(1,80) would work. You could embed this in a vlookup if the machine name is required instead of numbers 1-80.

 

[alexoigres]

thank you but ...I do need at least the machines to be audited twice a month..... this is why it take me long time to do the matrix every month

 

[alexoigres]

I need some help here...... I have tried so many variables of formulas..... even I tried =OFFSET($B$6,RANDBETWEEN(1,85),0)

still there are so machines from the list that they don't get audit and some machines they get audited 4 times...

any ideas?

thanks