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...