Hi again,
here is an proposal for solution, almost completely without formulas! It actually uses a quite powerful built in functionality in Excel, called "Advanced filter".



I attach a worksheet with the result, but you need to read the steps below to create this result. Please note that my naming of dialog boxes, alternatives etc might not be 100% correct, since I am running a Swedish installation and my translation might not be 100% equal.

Due to the language effect i recommend you to try my solution out NOT using my attached file, but instead using your own file.

In column D there are the so called "filter criterias". First you have to copy the fomulas in column D to your own sheet. Actually column C would have been possible to use as criterias (only changing the header to "Country"), but then it would have the effect that a country written "Angola" would be interpreted as "Angola*" (joker sign). If you enter country "Niger" it would also select "Nigeria" which would not be correct, therefore we need column D, which says that the country name has to be exactly equal.

Now select the menu "Data" and then "Filter" and at last "Advanced filter" (for repetitive use I recommend inserting this command as an icon in your Excel sheet).

1) Select the radiobutton "Copy to another location"

2) At list area (database area?) press the button to the right and mark your area (for example A1:B21) + enter.

3) At criteria area (?) press the button to the right and mark your area for criterias (for example D131) + enter.

4) At "Copy to" (?) press the button to the right and mark the start of your area for output (for example the cell E1) + enter.

Press OK and the list is there!

You can read more using "help" in Excel and search for "Advanced filter" or look here:

http://office.microsoft.com/en-us/ex...001781033.aspx (at the very end (see the header "Notes" about 20 lines from the bottom) there is some good pieces of information about naming areas.

Kind regards
Bjorn

Attached Files

compare countries 4.xls (43.5 KB, 15 views)

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)