S
Steve
I have this worksheet where I have items in the third column that
match up with items from the second column corresponding to the tenth
increment decimal numbers in the first column. In the example below,
the first 3 numbers in the third column match up with numbers in the
second column and the rest of the numbers are "0" up until you get to
the next set of tenth decimal numbers starting with 2 in the first
column. I need the fourth column to first list the matching numbers
from both the second and third columns and then list the rest of the
non-matching numbers from the second column, (in place of the zeros).
Any help would be greatly appreciated.
Thanks,
Steve
1.1 30 30 30
1.2 75 167 167
1.3 110 405 405
1.4 167 0 75
1.5 245 0 110
1.6 405 0 245
1.7 455 0 455
2.1 33 33 33
2.2 88 110 110
2.3 110 0 88
2.4 167 0 167
3.1 54 54 110
3.2 124 124 124
3.3 455 455 455
match up with items from the second column corresponding to the tenth
increment decimal numbers in the first column. In the example below,
the first 3 numbers in the third column match up with numbers in the
second column and the rest of the numbers are "0" up until you get to
the next set of tenth decimal numbers starting with 2 in the first
column. I need the fourth column to first list the matching numbers
from both the second and third columns and then list the rest of the
non-matching numbers from the second column, (in place of the zeros).
Any help would be greatly appreciated.
Thanks,
Steve
1.1 30 30 30
1.2 75 167 167
1.3 110 405 405
1.4 167 0 75
1.5 245 0 110
1.6 405 0 245
1.7 455 0 455
2.1 33 33 33
2.2 88 110 110
2.3 110 0 88
2.4 167 0 167
3.1 54 54 110
3.2 124 124 124
3.3 455 455 455