New filter function can you return all in a column

[Fanta0575]

Hi all, in cell L3 I have a drop down menu that gives me the option of (y,n,or all) my column for invoice paid (column g) is either a or a . I have the new filter operation in use and I can filter for y or n because that is the data contained in column g. Is there a way I could use an (if) with the filter function to return all the data in column g if I select (all)

from my drop down menu in l3!

 

[Fanta0575]

Hi all, in cell L3 I have a drop down menu that gives me the option of (y,n,or all) my column for invoice paid (column g) is either a or a . I have the new filter operation in use and I can filter for y or n because that is the data contained in column g. Is there a way I could use an (if) with the filter function to return all the data in column g if I select (all) View attachment 1512from my drop down menu in l3!

BTW
Formula in i5 is

=(SORT(FILTER(A2:F440,(B2:B440=J3)*(A2:A440>=I2)*(A2:A440<=K2)*(G2:G440=L3),"None Recorded In Period")))

 

[RoryA]

You could use:

=(SORT(FILTER(A2:F440,(B2:B440=J3)*(A2:A440>=I2)*(A2:A440<=K2)*(IF(L3="All",1,G2:G440=L3)),"None Recorded In Period")))

 

[Fanta0575]

You could use:

=(SORT(FILTER(A2:F440,(B2:B440=J3)*(A2:A440>=I2)*(A2:A440<=K2)*(IF(L3="All",1,G2:G440=L3)),"None Recorded In Period")))

Thank you so much for this RoryA, I have applied this to my supplier drop down menu list as well, it means I have a much more dynamic way of filtering information, this new filter function is amazing and much more user friendly than having to do array formulas