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)))
Try this:
=LET(pullrows,CHOOSEROWS(Combined_tblFinancials,IFERROR(XMATCH(Sayfa1!A2:A148,Combined_tblFinancials[itemCode]),0)),CHOOSECOLS(pullrows,SEQUENCE(,6,2,2)))
Without access to CHOOSECOLS/ROWS, you might use:
=INDEX(Combined_tblFinancials,IFERROR(XMATCH(Sayfa1!A2:A148,Combined_tblFinancials[itemCode]),0),SEQUENCE(,6,2,2))
- I did not implement what you said. I uploaded my excel file in its original form. I have re-uploaded the file if you want to help.
Thanks for sharing the workbook.
Here is the formula. I kept your filter but added CHOOSEROWS to pull the rows that match your subtotals. The subtotals are stored as a constant in the named item 'rowheaders'
=LET(filtered,FILTER(Combined_tblFinancials[[itemDescTr]:[2021/6]],Combined_tblFinancials[Symbol]=B1),CHOOSEROWS(filtered,XMATCH(RowHeaders,TAKE(filtered,,1))))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?
