Applying filtering on data validation selection

Good morning

I have a cover sheet in excel which I would like to be a dropdown and another sheet that contains the data. Basically I would like to select the country name from the dropdown on the cover page and it should then automatically filter the data on the 2nd sheet based on my selection on the cover page.

Is that possible?

Thank you in advance,
Anton

try:

Formula:

Please Login or Register  to view this content.

and

Formula:

Please Login or Register  to view this content.

Hi Sandy

Can you please show me in the excel? Not sure how this formula is going to filter my data...

Kind regards,
Anton

Ok, no problem:

Ups , I lost multiname of countries

Thanks I will now mark it as solved.

Glad to help

I saw you've duplicated country [Italy] so I don't know it is mistake or it should be duplicated.
Here is solution for non-duplicated or duplicated in G1 and down, and H1 and down.

regards