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 'points' to Knr=2
Knr=2 'points' to Knr=3
.
.
.
.
Knr=9 'points' to Knr=10
Knr=10 'points' to Knr=1 linking back to Knr=1

and a CHAIN is made up of 10 links!

This CHAIN can be cut into smaller chains by ADDING a number to Knr and you'll get Knr' - try replace the 0 with a number ... lets say 1 !

Then you'll get 10 chains each with only 1 link !

If you replace 0 with 2 you'll get 1 chain with 10 links

If you replace 0 with 3 you'l get 2 chains with 5 links each.

I need a FORMULA

OR

some VBA code that can tell me how many chains the is in the Knr' columb

when you add a number to Knr !

I think I'll have to SELECT the range C8:17 first !

Do you have any ideas how this could be done ?

WHAT ... how to attach an Excel Sheet ?