Customfilter function in Excel -- 2
Budget: ₹750 – ₹1,250 INR
Custom Function should behave like filter function in Excel with one unique condition
Ex.
1) let say I have table consist of fruit column, city column and Date column where we transports fruits to cities
a) get fruits that are transported to a Mumbai on 5th Nov 22
can get using regular excel filter function
=Filter(table[fruits], (table[city] = "Mumbai")*(table[Date]=5th Nov 22), "Nill")
In this filter function, it will check each element in city array equal to Mumbai, same go date array
b) get fruits that are transported to a Mumbai on all Dates
using regular excel filter function by completely avoiding date criteria in function
=Filter(table[fruits], (table[city] = "Mumbai"), "Nill")
Here i want change
I want a customfilter function::
where date criteria should be included
=CustomFilter(table[fruits], (table[city] = "Mumbai")*(table[Date]="All"), "Nill")
when in a criteria equal to All, whole array to be select instead of check each element in the array equal to All.
Ex.
1) let say I have table consist of fruit column, city column and Date column where we transports fruits to cities
a) get fruits that are transported to a Mumbai on 5th Nov 22
can get using regular excel filter function
=Filter(table[fruits], (table[city] = "Mumbai")*(table[Date]=5th Nov 22), "Nill")
In this filter function, it will check each element in city array equal to Mumbai, same go date array
b) get fruits that are transported to a Mumbai on all Dates
using regular excel filter function by completely avoiding date criteria in function
=Filter(table[fruits], (table[city] = "Mumbai"), "Nill")
Here i want change
I want a customfilter function::
where date criteria should be included
=CustomFilter(table[fruits], (table[city] = "Mumbai")*(table[Date]="All"), "Nill")
when in a criteria equal to All, whole array to be select instead of check each element in the array equal to All.