Download this data table, save it to the Desktop of your local machine and open it in Excel!
Add two new columns to the table!
- In the next empty column, display the years based on the first four characters of column C!
- In the next empty column, create the corrected list of codes (XLOOKUP)!
Where the old code appears in column A, look up the new code in the provided auxiliary table! The codes that are not found in the auxiliary table haven't changed so in those cases the original code (according to column A) must be used.
Show the number of applicants according to column D, broken down by year and faculty!
- In an empty area (N2), display the years shown in the data table!
The perfect solution requires a sorted dymamic list!
- Next to the previous column (O1), display the Faculty Codes side by side!
The perfect solution requires a sorted dymamic list – preferably using the previous, corrected list.
- Display how many people are listed in column D in each year and each faculty in the general procedure (*Á)!