Advanced Filiter Data Validation List

[IronSiren]

Hello I saw a post similar to mind I tried to make it work but can't get it to work


I have two worksheets

1 Worksheet Name = Market Dashboard

2 Worksheet Name=Formula Page


Basically the Market Dashboard is using a data validation list which allows users to pick several different countries and the data populates based on which country is selected. My issues is someone as always asked if have a Select All option of course I do "NOT". I'm using a complex formula to make the data validation list work by country

this is the formula =IFERROR(INDEX('Formula Page'!$B$2:$B$861,MATCH(0,IF('Formula Page'!$A$2:$A$861='Market Dashboard'!$B$2,COUNTIF('Market Dashboard'!$A$5:$A5,'Formula Page'!$B$2:$B$861),1),0)),"").


Can anyone tell me with using this formula is possible to allow me to create the select all in option in the drop down list and all of the countries data pulling from the formula page will populate.


Or should I create a VBA code that recognizes the select all option and will just populate the data that way. I'm just concerned that it will overwrite the formula above and the option to select different countries will go away help. I can provide more details if need

 

[Pat_Mc_64]

Thought... Can you create a separate selection box where the user would 1st chooses 'ALL' or "By Country" (I'd default to 'By Country')... then you could enhance your complex formula with an If statement (then refer to that selection} = "ALL" then use a wildcard or nothing "" (whatever you would put to not limit the selection by country)?