Multiply Values in Same Column Based on Conditional

[samgregory5]

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.

[Qiu]

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

[sparksun · Accepted solution]

One way to get it done

[samgregory5]

Thank you!!!!