Imperterritus
New Member
- Joined
- Feb 14, 2019
- Messages
- 1
Hello.
Is there any way to exclude the cell from the range? Here is the deal, this is how my sheet looks now (grey cells doesn't contain a formula)
I2:I11 - people that need to be connected to the task (there are 6 tasks - M3:M8 ; H15:H20)
J2 - there is RAND() formula
N3:N8 there is =INDEX(I$3:I$11;MATCH(LARGE(J$3:J$11;M3);J$3:J$11;0);0) - so it is giving me randomly one person per task (without reps)
But the thing is: if person 8 was attached to the task number 1 - he can't be attached to the same task in the next week. That is why i have created A2:G11. For example cell B3 contains: =IF(A3=I15;2;1). So if someone was arleady attached to task number one - there will be "2".
Now i would like to modify the formula from N3:N8 that would exclude every single cell that contains "2" (so the same person won't be attache in new week).
If anything is not clear as crystal, don't hesitate to ask.
Best regards
Is there any way to exclude the cell from the range? Here is the deal, this is how my sheet looks now (grey cells doesn't contain a formula)
I2:I11 - people that need to be connected to the task (there are 6 tasks - M3:M8 ; H15:H20)
J2 - there is RAND() formula
N3:N8 there is =INDEX(I$3:I$11;MATCH(LARGE(J$3:J$11;M3);J$3:J$11;0);0) - so it is giving me randomly one person per task (without reps)
But the thing is: if person 8 was attached to the task number 1 - he can't be attached to the same task in the next week. That is why i have created A2:G11. For example cell B3 contains: =IF(A3=I15;2;1). So if someone was arleady attached to task number one - there will be "2".
Now i would like to modify the formula from N3:N8 that would exclude every single cell that contains "2" (so the same person won't be attache in new week).
If anything is not clear as crystal, don't hesitate to ask.
Best regards
Last edited by a moderator:
