Panel data calculation in single column.

Dear all,

my panel data set consists of 28 countries for which I have one variable on an annual base for 18 years (1998 until 2015). The data set is strongly balanced though there are some data gaps. Column A consists of all countries, column B of the years and column C the data for the variable.

For each given year I would like to calculate the difference in the variable for all country-pairs. For example:


Name: Unbenannt.png
Views: 15
Size: 17.3 KB


In this example I am interested in the difference in the GDP between Germany – UK, Germany-Belgium and UK-Belgium in the year 1998. In addition, I would like to calculate the differences for those three country-pairs for the years 1999 and 2000. However, I do not want to calculate differences across different years.

Can you help me please to compute those differences? I also have to make sure that Excel computes only differences if data is available for both countries instead of filling gaps with a value of zero.

Thank you very much.

Kind regards