Hi community.
I would like to find the GDP for 16 countries automatically. Find the list of countries are in the sheet 2.
Capture.PNG
Thank you for your help.
Hi community.
I would like to find the GDP for 16 countries automatically. Find the list of countries are in the sheet 2.
Capture.PNG
Thank you for your help.
Last edited by Luu4466; 12-04-2020 at 11:56 AM.
What are the expected results? Fill them in manually for the first three rows and tell us how you have calculated them.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi! I want just to upload GDP of these 16 countries with a formula, or with a source and display them.
What do you mean? Formulae cannot work out a country's GDP.
If you mean from the web, then you need to find a source (we don't do that for you), and then see if someone can help you to scrape the data (assuimg it's permitted from the site - you'll need to check this first).
All right. Thank you for your answer
The new excel data types only available in MS365
https://support.microsoft.com/en-us/...8-f1a89e210877
Thank you @Bo_Ry, it's really helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks