Multiply two field in matrix

[igorfv]

Hi my friends,

How do multiply two fields in the matrix with the logic below? Give me a sample, please.

The logic for column 1 and row 1 - SPAG1:

The logic for column 1 and row 2 - SPAG1:

The logic for column 2 and row 1 - SPAG2:

The logic for column 2 and row 2 - SPAG2:

Thanks!

Igor Valle

[MeganBowers]

Hi @igorfv , see the attached solution, which makes use of the filter, append, and formula tools in order to generate column D and E in your spreadsheet

[Qiu]

@igorfv 
We can also try a Batch Macro for this case.

[igorfv]

Hi @MeganBowers  and @Qiu

Worked fine. Thanks a lot for your support.

Have a nice day.

Igor Valle

[Qiu]

@igorfv 
Glad to be helpful.