Formula using offset and Match

[vmohan1978]

All ,
I am having 1000 + rows like below mentioned here , I want the difference mat

In Column A there are 3 numbers separated by forward slash

The first number is beam number
the second number is node number
The third number is load case number
I required difference of Fx matching the node number and load case number

Fx Fy Fz Mx My Mz
314/38397/1001 (C) 23658 642 434 0 -1475 2186

314/38397/1002 23621 644 445 0 -1505 2186
314/38397/1003 23761 643 436 0 -1481 2188
314/64/1001 23451 642 434 0 825 -1217
314/64/1002 23414 644 445 0 852 -1218
314/64/1003 23553 643 436 0 831 -1221
731/10675/1001 28114 232 178 0 -176 321
731/10675/1002 28118 234 196 0 -228 325
731/38397/1001 27862 232 138 0 975 -1173 4204(27862-23658)
731/38397/1002 27866 234 196 0 1035 -1182 4245(27866-23658)

 

[vmohan1978]

The result i required is 4204 difference of( 27862-23658)
4245 ( difference of (27866-23658)

 

[BBD]

Hi Mohan,

Where does the number 23658 come from ?

Thanks,
BD

 

[vmohan1978]

Hi , find attached the file for more clear explanation

 

[Somendra Misra]

Hi,

See this file. Yellow cells.

Regards,

 

[BBD]

Hi Mohan,

You will need a helper column. Refer the attached file.

Thanks,
BD

 

[vmohan1978]

Misra and BBD

The formula worked perfectly . Thanks very much for your precious time in solving the query.