Hi Everyone,
Can you help me with a problem Im having with my formula. I have 3 tabs of data labelled April 2022, May 2022, June 2022, all the cells and data in these tabs are in the same positions.
I am trying to create a filter formula on a new sheet to filter between 2 date ranges which I type into 2 cells & filter down the refrence which I also type into a search box.
At the moment I am only able to filter 1 tab between 2 date ranges and search for a exact refence using the below formula but I want it to search for just the first 3 letters of the refrence and it to search through all 3 tabs.
=FILTER('June 2022'!A2:K2000,('June 2022'!A2:A2000>=H2)*('June 2022'!A2:A2000<=I2)*('June 2022'!B2:B2000=G2))
I have tried the below formula to make it search through all 3 tabs aswell but it keeps coming up CALC
=FILTER('April 2022:June 2022'!A2:K2000,('April 2022:[June 2022]June 2022'!A2:A2000>=H2)*('April 2022:[June 2022]June 2022'!A2:A2000<=I2)*('April 2022:[June 2022]June 2022'!B2:B2000=G2))
I have also tried the below formula which works to filter the refrences down by the first 3 letters but I cant get this to work with the date range aswell.
=FILTER('June 2022'!A2:K2000,ISNUMBER(SEARCH('April,May,June'!G2,'June 2022'!B2:B2000)), "No Results")
Can anyone help me please.
Thanks
Can you help me with a problem Im having with my formula. I have 3 tabs of data labelled April 2022, May 2022, June 2022, all the cells and data in these tabs are in the same positions.
I am trying to create a filter formula on a new sheet to filter between 2 date ranges which I type into 2 cells & filter down the refrence which I also type into a search box.
At the moment I am only able to filter 1 tab between 2 date ranges and search for a exact refence using the below formula but I want it to search for just the first 3 letters of the refrence and it to search through all 3 tabs.
=FILTER('June 2022'!A2:K2000,('June 2022'!A2:A2000>=H2)*('June 2022'!A2:A2000<=I2)*('June 2022'!B2:B2000=G2))
I have tried the below formula to make it search through all 3 tabs aswell but it keeps coming up CALC
=FILTER('April 2022:June 2022'!A2:K2000,('April 2022:[June 2022]June 2022'!A2:A2000>=H2)*('April 2022:[June 2022]June 2022'!A2:A2000<=I2)*('April 2022:[June 2022]June 2022'!B2:B2000=G2))
I have also tried the below formula which works to filter the refrences down by the first 3 letters but I cant get this to work with the date range aswell.
=FILTER('June 2022'!A2:K2000,ISNUMBER(SEARCH('April,May,June'!G2,'June 2022'!B2:B2000)), "No Results")
Can anyone help me please.
Thanks