Custom user function in Excel -- 2
Budget: ₹400 – ₹750 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
=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
=Filter(table[fruits], (table[city] = "Mumbai"), "Nill")
C) I want a custom function::
=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
=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
=Filter(table[fruits], (table[city] = "Mumbai"), "Nill")
C) I want a custom function::
=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.