Hi my data looks like this
E 100
C 110
C 112
C 111
E 101
I need to calculate the difference between C's and E's for each row.
So it should look like this.
E 100
C 110 10
C 112 12
C 111 11
E 101 10
My tables are much longer but my problem is simply this. I need calculate the differences between rows for each type(C and E). I appreciate if anyone can give me an idea or advice.
E 100
C 110
C 112
C 111
E 101
I need to calculate the difference between C's and E's for each row.
So it should look like this.
E 100
C 110 10
C 112 12
C 111 11
E 101 10
My tables are much longer but my problem is simply this. I need calculate the differences between rows for each type(C and E). I appreciate if anyone can give me an idea or advice.