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
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
@igorfv
We can also try a Batch Macro for this case.
@igorfv
Glad to be helpful.