sample of data below:
1 -69720 69670
1 FALSE 69700
1 FALSE 69700
1 FALSE 69940
1 FALSE 69940
1 FALSE 69940
1 69940 69940
1 FALSE 69970
1 FALSE 69970
1 FALSE 69970
1 FALSE 70110
1 70110 70110
1 70110 70110
1 70110 70110
-1 0 0
-1 70100 0
-1 FALSE 0
-1 FALSE 0
1 FALSE 0
1 70100 0
What I want to do is I need to do is sort of complex I think. What I'm trying to do is post info to column d which is blank based on mutliple conditions.
Any time the first column (a) changes from 0,or 1,or -1 post a number the number from column "b" to column "d". Then after that if column "b" has a number in it and column "a"'s value hasnt changed then post value from column "b" to column "d" and dont post anything else in column "d" until the value in column "a" changes to 0, or 1, or -1.
Below is what it should look like when the formula is written in column "d"
1 -69720 69670 -69720
1 FALSE 69700
1 FALSE 69700
1 FALSE 69940
1 FALSE 69940
1 FALSE 69940
1 69940 69940 69940
1 FALSE 69970
1 FALSE 69970
1 FALSE 69970
1 FALSE 70110
1 70110 70110
1 70110 70110
1 70110 70110
-1 0 0
-1 70100 70150 -70100
-1 FALSE 70140
-1 FALSE 70140
1 FALSE 70140
1 70100 70150 70100
Please find a sample spreadsheet attached
Bookmarks