nburaq
Board Regular
- Joined
- Apr 2, 2021
- Messages
- 222
- Office Version
- 365
- 2019
- Platform
- Windows
Hi All,
I have two similar tables at two different sheets. Is there any possibility to combine these two filtered results to show at another sheet? Maybe combination of filter and vstack?
I dont need unique values etc.. it is enough if it is filtered based on search
PS: I use this formula based on key search (Sheet1 result page, keyword at B1)
=FILTER(Sheet1!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet1!$A$2:$A$999));"No Results")
=FILTER(Sheet2!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet2!$A$2:$A$999));"No Results")
I have two similar tables at two different sheets. Is there any possibility to combine these two filtered results to show at another sheet? Maybe combination of filter and vstack?
I dont need unique values etc.. it is enough if it is filtered based on search
PS: I use this formula based on key search (Sheet1 result page, keyword at B1)
=FILTER(Sheet1!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet1!$A$2:$A$999));"No Results")
=FILTER(Sheet2!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet2!$A$2:$A$999));"No Results")