# Excluding cells from the range (drawing formula)

#### Imperterritus

##### New Member
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

Last edited by a moderator:

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Hello, your image doesn't show up.

Replies
0
Views
374
Replies
1
Views
222
Replies
3
Views
265
Replies
8
Views
72
Replies
5
Views
280

1,203,027
Messages
6,053,119
Members
444,640
Latest member
Dramonzo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back