Subtracting specific rows of specific columns

[Arunima_S]

Hi there,

I have a simple issue where I am trying to subtract Row(Record ID) 6 from Row(Record) ID 10 for columns A, C and D only.

Input

Record ID	A	B	C	D	E
6	100	210	210	543	352
7	100	453	134	543	352
8	100	453	134	543	352
9	100	453	134	452	352
10	500	453	134	453	352

Output

Record ID	A	B	C	D	E
6	100	210	210	543	352
7	100	453	134	543	352
8	100	453	134	543	352
9	100	453	134	452	352
10	400	453	-76	-90	352

What would be the best/easiest way to achieve this?

Thanks for your help!

Aria

[PhilippK · Accepted solution]

Hi @Arunima_S ,

please find a solution attached.

Best regards

Phil

[Arunima_S]

This works just as expected! Thank you