Forum Discussion
Solved
Sequence Issue
Dear Experts, Greetings! I have an issue like below, where exported a list from txt file and it has report like below:- Now, the empty cells, should be such that af...
See attached suggestion in column B.
There are two possibilities. The first is that you are using 365 and the other that you should be using 365. To fill a value down requires the formula
= SCAN("", status, LAMBDA(x,y, IF(y, y, x)))
placed in the first cell of the fill down sequence,
Better still is to define a Lambda function so that your solution becomes
"Worksheet formula"
= Filldownλ(status)
"Definition" Filldownλ
=SCAN("", s, LAMBDA(x, y, IF(y, y, x)))While I think of it, PowerQuery also has the ability to perform FillDown tasks and can be used with Excel 2010 and onwards.