Hi again again!
Here is another solution.

Enter your countries in column D, use the filter button in cell A1 to filter only "Yes".

Kind regards


Bjorn (still investigating yet another alternative)

Attached Files

compare countries 5.xls (44.5 KB, 15 views)

Hi for the third time,
here is a third solution (formula based).

There are two named areas in the sheet ("Data" and "Countries").
The error codes in column G and H you can handle according to my first very proposal(s).

Kind regards
Bjorn

Attached Files

compare countries 6.xls (50.5 KB, 16 views)