Forum Discussion
FILL lambda: Fill blank cells in Multiple direction (↓↑→←) across 2D arrays
Thank you for sharing. not sure when I might use but neat none the less.
Could also improve the description because at least for me I wasn't clear on what it would do. Basically it will take a range and spit that range back out but any blanks or "" will be 'filled' based on the last available value to the left,right,up, or down so a fill right will take the last value to the left of a series of blanks and fill that value to the right.
That said, you have a unknown function name in your FILL function 'clean_arr'
Not sure what that was/is supposed to do but I replaced is with 'array' and it seems to work in the cases I tried
In trying some things it is interesting if you have an #N/A Error value it will 'skip' that cell and that cell becomes blank instead of the error. but if you have multiple directions then it will get filled in on the second direction. Other errors like #NAME? and #DIV/0! are treated like values (and maybe that is what 'clean_arr' was intended to address?