That's an exerpt from the list:



What I want:

A dropdown menu for "indicators" => I only want to see one indicator at once (and that for all the countries)

=> next to the country's entry it should show the value for the indicator (i would like to have exactly the value of the year 2011, dont care about 1960-2010)

If you don't understand what I want, please let me know

Important: Because I give a donation, post here if u can help me, as it's not fair for those who post here if I answer to PM's as well.=> first to help gets the fg


To explain again what I want on an example:
Country name ... Country Code ... Here I want to choose the indicator and in the country's line see the value for 2011 ... Indicator Code[/I]
Afghanistan ... AFG ... country's value for that indicator in 2011 ... blabla
Albania ... ALB ... country's value for that indicator in 2011 ... blabla
Algeria ... DZB ... country's value for that indicator in 2011 ... blabla
...

(for all countries that)




please don't post a video without explaining anything, as i don't really have a clue on how to do that kind of stuff.
if you want the file, its availaible at world bank's site: http://data.worldbank.org/data-catalog/world-development-indicators (WDI excel zip => but its 72mb)

This post was edited by spencer66 on May 31 2013 01:43pm

Highlight the data in the column that you want to filter by, so in this case "indicators". Click on the Data tab and then click the Filter button. A little icon should appear on the top indicator cell, click this and a drop down menu appears, uncheck the things you don't want to see.