Subtraction of columns in a row

I am having a data table subtract.xlsx (9.0 KB) in which I want the output in Column H, I,J , rest of the columns are there in the data table (where A,B, C,D,E,F has a total in the last row),and
H = E- A , I = F- B, J = G - C i.e. Subtraction of E and A and so on.

Please help


Check as below for your reference

Hope this helps you


@Srini84 Thanks for the reply but in this solution for loop is used having subtraction to do in more than 1 row whereas i want to do the subtration in one row but the values are coming from different columns.

Is there any linq query which i can use.

and i am unable to find the solution of my problem on other platforms also

have a look here:
Swara_Soni_Substract.xaml (8.1 KB)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.