Help,

I'm working on a work rota,
I've got a list of staff in column A and there are 5 duties they could be
assigned to in columns B C D E & F, I need to randomly assign each member of
staff a duty without any member appearing twice.

Any help is appreciated.