Determine Mulitiplier from data

[mrsmirf]

Let say I have a list of data (which i do). What can I do to find the multiplier used for each of the numbers? For instance if every value in a list was multiplied by some constant and I need to find out what that constant was.

[martindwilson]

try
=GCD(A1:A10)

[newdoverman]

You must know what the original value was and divide that into the new value. The answer is the multiplier.

[Richard Buttrey]

Nice one Martin.

I freely admit I never knew that one existed. So I just started playing around with it and it seems rather curious.
The help does say it only works with integer multipliers and truncates to an integer if a decimal multiplier is used. So 5 will work and 5.1 will use the value 5, but seemingly 5.2 and other decimals results in the value 1.

As an aside I wonder if anyone has ever sampled all the functions to determine the most used (I'm guessing =SUM closely followed by =VLOOKUP). I hazard a guess that this =GCD is rarely used.

Has anyone any information on this?

[newdoverman]

The GCD may or may not be the answer. Other denominators are also possible depending upon the numbers involved.

[mrsmirf]

try
=GCD(A1:A10)

This worked with the sample set I created. However, in some cases the multiplier was less than the actual multiplier.

[mrsmirf]

Here's my solution. Essentially I just did a column of GCD then I did a LCM function on the GCD column to get the multiplier.