Hello,
In the formula underneath, the number 19 is variable.
In cell A1, I used a count row formula, so I would like to refer to that cell.
Is this somehow possible with indirect? I can't get it to work
=SORT(FILTER((Helpersheet!AB2:BD19);Helpersheet!BD2#<>"");1;1)
Thanks in advance
In the formula underneath, the number 19 is variable.
In cell A1, I used a count row formula, so I would like to refer to that cell.
Is this somehow possible with indirect? I can't get it to work
=SORT(FILTER((Helpersheet!AB2:BD19);Helpersheet!BD2#<>"");1;1)
Thanks in advance