Missing formula OR VBA code ??
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 ?
|