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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
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