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)

Additionally: the same for years => Choose for example 2011, see only one indicator at the same time (there's over 1200) and see that for each country

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 down see for each country 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)




don't post any videos, help me exactly for my list please.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:36pm

http://forums.d2jsp.org/forum.php?f=257

your welcome

mark everything

Data - List - Add list

not sure how its in your language...

need more than that :-D

how do i do with the countries for example? (because first i have 1200times afghanistan, then 1200 times albania and so on)

i see you are german, i am german too
could you pm me a german desrcitption of the task?

still dont understand what do u want...

i will answer this in german - think thats easier for him to understand


also in mysql heißt das was du suchst SELECT DISTINCT.. wenn man danach googlet findet man genau das hier:
" erledigt der Spezialfilter mit der Option keine Duplikate und an eine andere Stelle mit Angabe der Startzelle - Voraussetzung ist eine Überschrift über dem Bereich, da sonst der erste Datensatz als diese angenommen wird..."
(http://www.ms-office-forum.net/forum/showthread.php?t=231634)

hab hier leider kein 2007er excel aber vllt konnte ich dir damit ja helfen
wenn exakt das was der da oben geschrieben hat nicht hilft solltest du mit dem zauberwort DISTINCT trotzdem zu ner lösung kommen

/edit
jetz hab ich hier extra excel 2010 installt ^^
ich glaub ich hab das alles zu kompliziert verstanden.. das is wohl noch einfacher:
"Daten" -> "Filtern"
dann haste ja für jede spalte nen dropdown.. jetzt 2 sachen machen:
- 1. den indikator wählen den du brauchst
- 2. in der spalte 2011 beim filter ganz nach unten scrollen und "(Leere)" abwählen

jetz haste genau das was du suchst.. nur den einen indikator und nur die die es 2011 auch wirklich gab

hab ichs jetzt richtig verstanden?

This post was edited by snodo on May 31 2013 02:09pm

I don't know if you got help yet.

Highlight your entire data (all cells with data you want to include and filter through).
Under the "Insert" (Einfugen) ribbon pick "Table" (calendar looking grid)
This gives you drop-down columns at the top where you can check/uncheck each unique value in the column.
The bottom row of this Table also has a blue *. You can type any new data in this cell and it will extend the table down one cell. This is good if you want something like averages to keep updating as you add more data.

Hope this was what you were looking for.

This post was edited by Quoz on May 31 2013 10:19pm

Highlight the data in a column. Click on the Data tab and then click the Filter button. A little icon should appear on the top cell, click this and a dropdown menu appears, uncheck the things you don't want to see. It will now hide rows that don't contain this value.

This post was edited by RzChaos on Jun 1 2013 06:25am

The pivot chart function is super useful and will allow to manipulate and visually see dynamic ranges for a vast number of parameters.
Anything more analytical (not just filtered) can be done by adding helper columns to do so.