Challenge #275: Greatest Common Denominator

[AkimasaKajitani]

My solution.

スポイラ

Outer Iterative Macro


Inner Iterative Macro (For getting GCD)

[balajilolla]

スポイラ

Solution Attached

[apathetichell]

スポイラ

four summarize tools do the heavy lifting..

[phottovy]

My solution:

スポイラ

I ended up using an iterative macro that follows the example of Euclid's algorithm from this link:

Greatest Common Factor (GCF, HCF, GCD) Calculator 

[achillesjing]

Here is my solution.

[Kenda]

スポイラ

[TonyA]

If there were more types of materials, I would have done this as a nested macro, but simpler here to just use the macro twice.

スポイラ

[ggruccio]

275!  Have we reached the summit?

スポイラ

Simple if you know how to use the Mod function.  Generated rows and divided by the row count to get Mod = 0 then only took the records that joined and used the Max.

[youngk313]

I have one easy solution which was getting the minimum difference between volumes. This makes the assumption that all datasets will have this format.

To be more general I created a Python script that checks the GCD for each group of volumes. 

[JasonHu]

スポイラ

Here is my submission.