7 |
9 |
18 |
20 |
36 |
4 |
10 |
22 |
28 |
31 |
7 |
12 |
17 |
19 |
28 |
4 |
7 |
16 |
17 |
28 |
10 |
22 |
25 |
27 |
38 |
Above is columns b through f .
Below is my if statement:
=IF(B2=B3,"0",IF(B2=C3,"1",IF(B2=D3,"1",IF(B2=E3,"1",IF(B2=F3,"1",IF(B2=B4,"0",IF(B2=C4,"1",IF(B2=D4,"1",IF(B2=E4,"1",IF(B2=F4,"1",IF(B2=B5,"0",IF(B2=C5,"1",IF(B2=D5,"1",IF(B2=E5,"1",IF(B2=F5,"1",IF(B2=B6,"0",IF(B2=C6,"1",IF(B2=D6,"1",IF(B2=E6,"1",IF(B2=F6,"1",IF(B2=B7,"0",IF(B2=C7,"1",IF(B2=D7,"1",IF(B2=E7,"1",IF(B2=F7,"1",IF(B2=B8,"0",IF(B2=C8,"1",IF(B2=D8,"1",IF(B2=E8,"1",IF(B2=F8,"1",IF(B2=B9,"0",IF(B2=C9,"1",IF(B2=D9,"1",IF(B2=E9,"1",IF(B2=F9,"1",IF(B2=B10,"0",IF(B2=C10,"1",IF(B2=D10,"1",IF(B2=E10,"1",IF(B2=F10,"1",IF(B2=B11,"0",IF(B2=C11,"1",IF(B2=D11,"1",IF(B2=E11,"1",IF(B2=F11,"1",IF(B2=B12,"0",IF(B2=C12,"1",IF(B2=D12,"1",IF(B2=E12,"1",IF(B2=F12,"1","CHECK"))))))))))))))))))))))))))))))))))))))))))))))))))
I didn't know that excel has a limited on the amount of nested if statements.
Basically I want to find out if the numbers on the starting row are in the same position when they previously appeared. Place a
zero for yes, a one for no, and a check if its not within range. I would also like to be able to change the range other than starting a new sheet in the workbook.
from list above the 3rd row in g through k
0 check 1 check 0
Any help would be greatly appreciated.
Alchemist