Forum Discussion

Brass Contributor

Aug 30, 2022

Solved

I'm missing a FORMULA or some VBA code that can ...

I have attached a Excel sheet with a little ridle I cant solve ! The Knr yellow columb to the left contains a 1 CHAIN of digits 1..10 if you 'follow' the pointer columb to the right: Knr=1 'poi...

Formulas and Functions

HansVogelaar
Aug 30, 2022
keldsor

The formula is

=GCD(MOD(C5-1,10),10)

keldsor

Brass Contributor

Aug 30, 2022

keldsor

Here is the 'attached' file:

https://docs.google.com/spreadsheets/d/1DzI3gp0GbgyoHtoU4pjdrP9T7DKxDz_q/edit?usp=sharing&ouid=109043885060180847964&rtpof=true&sd=true

HansVogelaar
MVP
Aug 30, 2022
keldsor

The formula is

=GCD(MOD(C5-1,10),10)
- keldsor
  Brass Contributor
  Aug 30, 2022
  Wav, very nice and very surpricing, I think !
  
  I know the functions you're using, but can't see how i the world you figured that out - can you explain a little more ?
  
  THX for your time !
  - HansVogelaar
    MVP
    Aug 30, 2022
    keldsor
    
    I started by writing down the number of chains for several combinations, and a pattern began to emerge.
    
    If the number of items and the step size don't have any divisors in common (i.e. the greatest common divisor is 1), stepping through the items will arrive at each and every element. so there is one chain.
    
    If the greatest common divisor is 2, one chain will connect all even values, and the other chain will connect all odd values, so there are two chains.
    
    Etc.