In range A1:BG2185 of this workbook, there is macro economic and demographic data for years from 1984 to 2009 (26 years) for 84 countries . Furthermore, there are 57 parameters being tracked for each of the 26 years for all 84 countries.
There are missing observations for some years across many parameters and many countries. If any country has more than 11 missing observations in any one parameter, then they should be depicted in the sheet named “Missing Observations”. The “Missing Observations” sheet should show three columns:
1. Country Name
2. Parameter with more than 11 missing observations
3. Observations missing
Filtering a database by both rows and columns
{ 34 Comments }