Forum Discussion
Creating Tables
Hello, I'm currently working on a project where I have to create/modify a table that I have to put down values where I have to substract using 2 values located in the same column. However I'm current...
For example in this table a column needs to generated by substracting sample 1 in column 1 and sample 5 in column 1 which also applies for 2-6, 3-7 and 4-8. And another column needs to be generated with the same application but on column 2.
| Column 1 | Column 2 | |
| Sample 1 | 5 | 3 |
| Sample 2 | 2 | 1 |
| Sample 3 | 1 | 3 |
| Sample 4 | 0 | 4 |
| Sample 5 | 4 | 8 |
| Sample 6 | 2 | 5 |
| Sample 7 | 1 | 2 |
| Sample 8 | 7 | 1 |
hi Anonymous
could you also paste the expected result column? for instance, where do you plan to put the subtraction result of sample 1 and 5?
The result will be
Column 1 Column 2 Difference Between 1 and 5 1 -5 Difference Between 2 and 6 0 -4 Difference Between 3 and 7 0 2 Difference Between 4 and 8 -7 3 Values for column 1 are 1,0,0,-7