Sharon1234
New Member
- Joined
- Aug 3, 2013
- Messages
- 17
I am trying to make a large spread sheet that will automatically fill in the 1's under the number if it appears between the start-stop columns; as shown in the example.
It will have many start stop columns filed in, for hundreds of numbers.
I can get it to work for the number if it is between the start-stop figures from one section; but I cant get multiple selections of start-stop values to work. The equation I have used for this is =AND(I$2>=$B4,I$2<=$C4) This gives me 'TRUE' or 'FALSE' which I can then convert to 1 or 0, if anyone knows how to make it a 1 in the first instance that would also be greatly appreciated.
Thank you in advance to anyone able to help
<tbody>
</tbody>
It will have many start stop columns filed in, for hundreds of numbers.
I can get it to work for the number if it is between the start-stop figures from one section; but I cant get multiple selections of start-stop values to work. The equation I have used for this is =AND(I$2>=$B4,I$2<=$C4) This gives me 'TRUE' or 'FALSE' which I can then convert to 1 or 0, if anyone knows how to make it a 1 in the first instance that would also be greatly appreciated.
Thank you in advance to anyone able to help
........ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | total | |||||||
Start | Stop | Start | Stop | |||||||||||||||||
5 | 5 | 7 | 10 | 1 | 1 | 1 | 1 | 1 | 5 | |||||||||||
2 | 3 | 7 | 10 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | ||||||||||
3 | 5 | 6 | 6 | 1 | 1 | 1 | 1 | 4 | ||||||||||||
<tbody>
</tbody>