Forum Discussion
Solved
just filter specific rows and columns
Hi, I want to filter only certain rows and columns. It may be on a different path. (vloop, hloop) but how can I do it in short way like filter. The table in the first picture is the result I got...
Try this:
=LET(filtered,FILTER(Combined_tblFinancials[[itemDescTr]:[2021/6]],Combined_tblFinancials[Symbol]=B1),INDEX(filtered,XMATCH(RowHeaders,INDEX(filtered,,1)),SEQUENCE(,7)))
Hi Patrick2788;
Did you manually enter the contents of the "Rowsheaders" constant?
This is not a problem, but others need an address.
In this, it writes directly to the line headers.
Is there a way to do this or did you type it manually?
You could run UNIQUE on the item column then select the formula in the formula bar and press F9. This will give you the constant to put in a named item.
Patrick2788 Thank you very much. You are amazing.