Formula to autofill neighbouring cells when a value is added to another

**2571** · 11-14-2012, 11:37 AM

Brilliant thank you Sixthsense that works perfectly

**2571** · 11-22-2012, 07:38 PM

Hi Sixthsense

I have just realised that using the formula that you provided doesn't stop me adding any other number in to the 2nd and 3rd columns when I have already added the 1 in the first.

when I add a 1 into the first column and I go to add another 1 in the second column it will not allow me to do it and throws up an error message which is exactly what I want it to do however if I add a 1 to the first column then add a 3 to the second column it happily allows me to do this without throwing up any errors is there anyway I can stop this from doing that??

Regards
Stacey

**:) Sixthsense :)** · 11-22-2012, 11:44 PM

@ 2571, I have suggested the formula based on your below lines

(an answer is provided by entering a 1 in the appropriate column) however what I am trying to work out is whether I can apply a formula to the cells to stop the user from entering another 1 in another column causing duplicate answers per question

I thought that the cell values will be marked with 1 only instead of any other characters.

If you are sure that the input values are only Numbers then use the below one

Formula: