Forum Discussion
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...
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 !
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.