shellp
Board Regular
- Joined
- Jul 7, 2010
- Messages
- 207
- Office Version
- 365
- 2021
- 2010
- 2007
- Platform
- Windows
Hello,
I am using Excel 365. I've created a list used in data validation that includes "All" as an option
If the user leaves it as "All" then the filter syntax will be
vs
if a value is selected.
How can I dynamically change the filter based on user's selection? I've tried creating a formula in another cell of "if All then <>"" else = F6" and referencing it as indirect() in the filter formula but that isn't working. Also, how do I reference it in the filter itself i.e. fieldname& filter syntax? Or with a comma and the filter syntax?
Any and all assistance greatly appreciated. Thank you so much.
I am using Excel 365. I've created a list used in data validation that includes "All" as an option
Excel Formula:
VStack("All",TOCOL(Sort(Unique(raw[Fiscal_Year]),1,1))
If the user leaves it as "All" then the filter syntax will be
Excel Formula:
<>""
Excel Formula:
=F6
How can I dynamically change the filter based on user's selection? I've tried creating a formula in another cell of "if All then <>"" else = F6" and referencing it as indirect() in the filter formula but that isn't working. Also, how do I reference it in the filter itself i.e. fieldname& filter syntax? Or with a comma and the filter syntax?
Any and all assistance greatly appreciated. Thank you so much.