I have a group of people that I want to have them peer-review each others reports. There are roughly 20 people who have 200 reports between them. I would like to create a template with formulas that can be ran each month to assign say 5 reports to be peer reviewed each month (or assign all out if thats easier). I would like the most tenured people paired with the lowest tenured. Example Data below.
Is there a way to create a formula that can match a person up with another at the opposite end of the tenure spectrum and return the report name? It doesnt need to be an exact tenure match (highest to lowest, 2nd higest to 2nd lowest, etc) and I would ideally like to randomize the assignments each month. The tenures, number of reports each person has is not evenly set so its not as easy as copy, flip, paste.... Let me know if you have any questions or suggestions. Thanks!
<tbody>
</tbody>
Is there a way to create a formula that can match a person up with another at the opposite end of the tenure spectrum and return the report name? It doesnt need to be an exact tenure match (highest to lowest, 2nd higest to 2nd lowest, etc) and I would ideally like to randomize the assignments each month. The tenures, number of reports each person has is not evenly set so its not as easy as copy, flip, paste.... Let me know if you have any questions or suggestions. Thanks!
| Name | Tenure (months) | Report Name |
| Bob | 15 | A1 |
| Bob | 15 | A2 |
| John | 10 | A3 |
| John | 10 | A4 |
| Mike | 5 | A5 |
| Mike | 5 | A6 |
| Sarah | 5 | A7 |
| Sarah | 5 | A8 |
| Kristina | 1 | A9 |
| Kristina | 1 | B1 |
<tbody>
</tbody>
