number patterns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if there is a function in Excel that would help me find
patterns in a given set of numbers. For a very simple instance, the number
set pattern for 3,6,9,12,15,18 is obiviously three. Thanks.
 
You need the greatest common divisor:

Returns the greatest common divisor of two or more integers. The greatest
common divisor is the largest integer that divides both number1 and number2
without a remainder.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

See Excel Help fo examples
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the =page! feature to transpose a row to column 0
how do I invoke formula pattern copying? 4
Calculate workdays for irregular work patterns 1
How to calculate the number of Workdays for irregular work pattern 1
Conditional Formatting 1
Cell Formatting by function 6
How can I count cells of a specific colour (pattern)? 1
Can I use 4 conditonal foamts in a column? 7

Back
Top