Forum Discussion
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
Thank you for your efforts, but I think there are functions that are not supported by my excel.
in the code it is showing this message: "_xlfn."
#AD? = #NAME? error
described on this site:https://support.microsoft.com/tr-tr/office/sorun-bir-xlfn-%C3%B6n-ek-bir-form%C3%BCl%C3%BCn-%C3%B6n%C3%BCnde-g%C3%B6r%C3%BCnt%C3%BClenir-882f1ef7-68fb-4fcd-8d54-9fbb77fd5025
What path should I follow?
Try this:
=LET(filtered,FILTER(Combined_tblFinancials[[itemDescTr]:[2021/6]],Combined_tblFinancials[Symbol]=B1),INDEX(filtered,XMATCH(RowHeaders,INDEX(filtered,,1)),SEQUENCE(,7)))- =LET(filtered,FILTER(Combined_tblFinancials[[itemDescTr]:[2021/6]],Combined_tblFinancials[Symbol]=B1),INDEX(filtered,XMATCH(RowHeaders,INDEX(filtered,,1)),SEQUENCE(,7)))
=INDEX(Combined_tblFinancials,IFERROR(XMATCH(Sayfa1!A2:A148,Combined_tblFinancials[itemCode]),0),SEQUENCE(,6,2,2))
Now I can use both. thank you for all your effort.
Why don't I have access to these functions?
"CHOOSECOLS/ROW/TAKE"Glad it worked! Those functions are only available in 365 and Excel web app.
- thank you very much.
