Multiply Values in Same Column Based on Conditional

I'm trying to create a product of all value in a column that share the same value in a different column.

As an example, in the picture below I am trying to create column C based on the values in columns A & B. All rows in column B that have the same value in column A, should be multiplied together to get the value in C.

Common Use Cases

Accepted answers

sparksun

One way to get it done

Group and then get product of all the grouped values.yxmd

All comments

Qiu

@samgregory5
I think we can do it by a Dynamic replace, but still working on it. 😁
Hope someone can enlighten us.

sparksun

One way to get it done

Group and then get product of all the grouped values.yxmd

samgregory5

Thank you!!!!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703