View Single Post
 
Old 03-07-2010, 12:02 PM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

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
File Type: xls compare countries 2b.xls (99.0 KB, 13 views)
Reply With Quote