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)))
Glad it worked! Those functions are only available in 365 and Excel web app.
thank you very much.
