Distribute data without repition

[garethrobertsleeds]

Hi All,

I am in need of a little help....

I organise monthly audits of work completed by the team. Essentially we all audit each others work; but we cannot audit our own work.

I would like a formula that will evenly distribute the jobs for audit without passing a job back to someone that owns the job originally. e.g. Gareth cannot audit a job Gareth owns, but can audit Zach or Claire's jobs. The Excel sheet attached should make it easy to understand.

So far I have tried: =INDEX(A2:A24,RANDBETWEEN(2,24)) but this duplicates data and I cannot get it to evenly spread the jobs amongst the team.

..... Can anyone help?