Hi there,
I have created a formula that I think solves your issue (see attachment). As you see, there has to be some formulas in column A and B to solve your issue (it is possible to move them further to the right if you like, but then you have to do a small modification).

In cell H2 there is a general formula, which can be copied down and right as far as you like.



I have created one "main solution", see sheet 2 (with correct error handling)
I have also to other alternatives, see sheet 3 and 4 (which creates "errors")

Kind regards
Bjorn

Attached Files

compare countries 2b.xls (99.0 KB, 13 views)

Hi again,
here is a slightly improved version. In this version, your list of countries doesn't have to be sorted.

Kind regards
Bjorn

Attached Files

compare countries 2c.xls (99.5 KB, 16 views)