Hi All,
I'm new here, i'm a lawyer working in London.
My boss has given me the additional responsibilities of doing our firms data analysis, so i'm starting to use excel properly for the first time in my life.
I'm pretty tech savvy but i've got no more than just basic experience with excel so i'm wrecking my brains trying to find the answer to the below. Any help would highly be appreciated.
I have to lists of the same countries that i have ranked using two separate metrics, i would now like to work out how i can find out the positional changes (either moved up or moved down) from each other.
List 1:
India
Pakistan
Iran
United Kingdom
Nigeria
USA
Bangladesh
China
Philippines
Canada
Albania
Egypt
Australia
Jamaica
Algeria
Morocco
South Africa
Afghanistan
Iraq
Somalia
Italy
Brazil
Ghana
Turkey
Russia
Hongkong
Lebanon
Zimbabwe
Sri Lanka
Syria
Nepal
Romania
Sierra Leone
Saudi Arabia
Spain
Colombia
Eritrea
Malaysia
New Zealand
Poland
Yemen
Israel
Uganda
France
Jordan
Libya
Tunisia
Germany
Kenya
Portugal
Sweden
Dominica
Ethiopia
Mauritius
Mexico
South Korea
Ukraine
Vietnam
Cameroon
Japan
Peru
Sudan
Thailand
United Arab Emirates
Greece
Kosovo
Singapore
Venezuela
Chad
Mongolia
Slovakia
Taiwan
Trinidad Tobago
Angola
Benin
Congo
Denmark
Ecuador
Gambia, the
Georgia
Kazakhstan
Liberia
Moldova
Palestine
Saint Lucia
Azerbaijan
Bulgaria
Burma
Kurdistan
Cuba
Czech Republic
Honduras
Indonesia
Ivory Coast
Kuwait
Norway
Tanzania
Uzbekistan
Zambia
Argentina
Austria
Belgium
Bolivia
Cyprus
Grenada
Guinea
Guyana
Hungary
Latvia
Namibia
Senegal
Serbia
Switzerland
Yugoslavia
Bahamas
Bahrain
Barbados
Belarus
Bosnia-Herzegovina
Bukino Faso
Cambodia
Chile
Croatia
Dominican Republic
El Salvador
Estonia
Finland
Holland
Ireland
Lithuania
Malawi
Malta
Mauritania
Montenegro
Myanmar
Netherlands
Panama
Papua New Guinea
Paraguay
Qatar
Saint Vincent and the Grenadines
Scotland
Seychelles, the
Solomon Islands
Suriname
Swaziland
Solomon Islands
Suriname
Swaziland
List 2:
USA
United Kingdom
Hongkong
Australia
Canada
South Korea
New Zealand
Germany
Israel
Indonesia
China
Saudi Arabia
Malaysia
Greece
Lebanon
Kazakhstan
Mexico
Ukraine
Japan
Sweden
Benin
Azerbaijan
Belarus
Netherlands
Paraguay
Singapore
Burma
Argentina
Switzerland
Venezuela
Guyana
Bahamas
Solomon Islands
Solomon Islands
Serbia
Taiwan
Ecuador
Grenada
Bahrain
Chile
Malawi
Montenegro
Papua New Guinea
Thailand
United Arab Emirates
Norway
Hungary
Yemen
Kosovo
Mongolia
Moldova
Kuwait
Cyprus
Guinea
Libya
Barbados
Estonia
Finland
Qatar
Suriname
Swaziland
Suriname
Swaziland
South Africa
Italy
Vietnam
Congo
Denmark
Ivory Coast
Namibia
Holland
Ireland
Mauritania
Panama
Scotland
Seychelles, the
Palestine
Czech Republic
Zambia
Bukino Faso
Cambodia
Croatia
Lithuania
Myanmar
Saint Vincent and the Grenadines
Bolivia
Latvia
Bosnia-Herzegovina
Dominican Republic
El Salvador
Malta
Brazil
Poland
Sudan
Tanzania
Austria
Senegal
Yugoslavia
Jordan
Gambia, the
Liberia
Saint Lucia
Cuba
Honduras
Belgium
Peru
France
Tunisia
Bulgaria
Kurdistan
Turkey
Mauritius
Uzbekistan
Kenya
Trinidad Tobago
Georgia
Egypt
Spain
Angola
Sierra Leone
Cameroon
Slovakia
Portugal
Dominica
Sri Lanka
Ethiopia
Nepal
Zimbabwe
Russia
Colombia
Chad
Uganda
Morocco
Syria
Romania
Eritrea
Philippines
Afghanistan
Ghana
Algeria
Iraq
Albania
Somalia
Jamaica
Nigeria
Bangladesh
Pakistan
Iran
India
So i'm trying to figure out what the positional change from the countries in list 1 are to list 2; eg; USA has moved up 5 places. How can this be done in Excel?
thank you in advance for your help
Bookmarks