I have two quick filters, when one of the quick filters shows "(All)" i want the other to display "" (essentially nothing).
I tried the following formula but its providing null results: If [filter1] = "(All)" then "" End
Thanks in advance,
I think it is better to see your sample workbook(.twbx) so that we can suggest you according to your dataset.
Prashant Sharma - India | LinkedIn
Retrieving data ...