Lambda Recursion Help

[samdthompson]

Hello, I have built a recursive Lambda which does not recurse. I cannot for the life of me work out which bit is going wrong other than the recursion. The main formula works well and manual recursion works exactly as it should. The aim is to remove "R" from the grid based on how many X's there are around them. The recursion should stop when there are no additional X's to remove. Note There may still be some X's left but not any that require removal.

Formula:
=_ValueRecursion(_rng,_initial_value)

Named Range:

=LAMBDA(_rng,_initial_value,
LET(
_up, OFFSET(_rng, -1, 0),
_right, OFFSET(_rng, 0, 1),
_down, OFFSET(_rng, 1, 0),
_left, OFFSET(_rng, 0, -1),
_x, MAP(_up, _right, _down, _left, LAMBDA(u,r,d,l, OR(u = "x", r = "x", d = "x", l = "x"))),
_txttosplit, _up & "," & _right & "," & _down & "," & _left, _txtsplit, LEN(_txttosplit) - LEN(SUBSTITUTE(_txttosplit, "R", "")),
_calc, IF(_rng = "W", "W", IF(_rng = "", "", IF(_x * _txtsplit = 1, "X", _rng))),
_current_count, COUNTA(FILTER(TOCOL(_calc), TOCOL(_calc) = "X")),
_finish, IF(_initial_value = _current_count, _calc, _ValueRecursion(_calc, _current_count)),
_finish)
)


Cheers

 

[samdthompson]

Solved.

This is unable to work as offset will not work in a recursion. Index can be used but in this specific use case the solution would be too large.

back to the drawing board

 

[AliGW]

Cross-posted here: https://www.excelforum.com/excel-formulas-and-functions/1426857-recursion-help.html

Most forums have the same rule about cross-posting. You don't appear to be aware of this, so please take a moment to read this:

A message to forum cross posters

Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online … Continue reading →

excelguru.ca

Thank you for your co-operation in future.