Spreadsheet: 35116d1232633259-using-index-and-match-to-find-the-2nd-matching-value-excel-problem
Sheet: Sheet3

MMU Course Code | Course code | Course Title | 2008-09-01 00:00:00 | RANK | 2008-10-01 00:00:00 | RANK | 2008-11-01 00:00:00 | RANK | 2008-12-01 00:00:00 | RANK | 2007-09-01 00:00:00 | RANK | 2007-10-01 00:00:00 | RANK | 2007-11-01 00:00:00 | RANK | 2007-12-01 00:00:00 | RANK
400X | L115 | Business Economics (Foundation) | 0 | 15 | 0 | 16 | 0 | 16 | 0 | 15 | 3 | 13 | 5 | 10 | 2 | 14 | 2 | 12
404X | L114 | Business Economics (Foundation) | 38 | 3 | 30 | 3 | 37 | 3 | 25 | 3 | 9 | 6 | 26 | 3 | 21 | 3 | 4 | 10
401X | M102 | Economics (Foundation) | 13 | 6 | 16 | 5 | 15 | 9 | 10 | 7 | 5 | 11 | 7 | 7 | 8 | 10 | 7 | 7
406X | L151 | Economics and Policy (Foundation) | 0 | 15 | 4 | 14 | 2 | 15 | 1 | 12 | 0 | 15 | 0 | 16 | 2 | 14 | 0 | 14
440X | RRC4 | French and Spanish (Foundation) | 12 | 7 | 14 | 6 | 19 | 5 | 3 | 11 | 6 | 8 | 11 | 6 | 13 | 4 | 10 | 5
440X | R101 | French Studies (Foundation) | 7 | 10 | 8 | 11 | 8 | 10 | 1 | 12 | 6 | 8 | 5 | 10 | 5 | 11 | 10 | 5
410X | V102 | History (Foundation) | 4 | 12 | 25 | 4 | 19 | 5 | 11 | 6 | 16 | 4 | 18 | 4 | 10 | 8 | 12 | 4
462X | G564 | Information and Communications (Foundation) | 2 | 14 | 6 | 12 | 8 | 10 | 7 | 8 | 1 | 14 | 3 | 13 | 2 | 14 | 0 | 14
461X | P101 | Information Management (Foundation) | 18 | 5 | 10 | 10 | 17 | 7 | 1 | 12 | 14 | 5 | 4 | 12 | 13 | 4 | 4 | 10
4511 | M100 | Law | 1169 | 1 | 1071 | 1 | 915 | 1 | 411 | 1 | 962 | 1 | 999 | 1 | 902 | 1 | 402 | 1
451X | M101 | Law (Foundation) | 165 | 2 | 171 | 2 | 171 | 2 | 129 | 2 | 110 | 2 | 118 | 2 | 170 | 2 | 90 | 2
471X | V501 | Philosophy (Foundation) | 6 | 11 | 5 | 13 | 5 | 13 | 6 | 10 | 7 | 7 | 7 | 7 | 4 | 12 | 5 | 9
470X | L201 | Politics (Foundation) | 23 | 4 | 14 | 6 | 8 | 10 | 7 | 8 | 5 | 11 | 2 | 14 | 9 | 9 | 1 | 13
473X | L233 | Public Services (Foundation) | 3 | 13 | 3 | 15 | 3 | 14 | 0 | 15 | 0 | 15 | 1 | 15 | 4 | 12 | 0 | 14
424X | L302 | Sociology (Foundation) | 12 | 7 | 12 | 8 | 16 | 8 | 13 | 4 | 19 | 3 | 6 | 9 | 11 | 6 | 6 | 8
465X | G451 | Web Development (Foundation) | 10 | 9 | 12 | 8 | 24 | 4 | 12 | 5 | 6 | 8 | 12 | 5 | 11 | 6 | 14 | 3
 |  |  | 1482 |  | 1401 |  | 1267 |  | 637 |  | 1169 |  | 1224 |  | 1187 |  | 567
 |  | Top 5 Views Each Month | 2008-09-01 00:00:00 |  | RANK | 2008-10-01 00:00:00 |  | RANK | 2008-11-01 00:00:00 |  | RANK | 2008-12-01 00:00:00 |  | RANK | 2007-09-01 00:00:00 |  | RANK | 2007-10-01 00:00:00 |  | RANK | 2007-11-01 00:00:00 |  | RANK | 2007-12-01 00:00:00
 |  | 1 | M100 | Law | 1 | M100 | Law | 1 | M100 | Law | 1 | M100 | Law | 1 | M100 | Law | 1 | M100 | Law | 1 | M100 | Law | 1 | M100 | Law
 |  | 2 | M101 | Law (Foundation) | 2 | M101 | Law (Foundation) | 2 | M101 | Law (Foundation) | 2 | M101 | Law (Foundation) | 2 | M101 | Law (Foundation) | 2 | M101 | Law (Foundation) | 2 | M101 | Law (Foundation) | 2 | M101 | Law (Foundation)
 |  | 3 | L114 | Business Economics (Foundation) | 3 | L114 | Business Economics (Foundation) | 3 | L114 | Business Economics (Foundation) | 3 | L114 | Business Economics (Foundation) | 3 | L302 | Sociology (Foundation) | 3 | L114 | Business Economics (Foundation) | 3 | L114 | Business Economics (Foundation) | 3 | G451 | Web Development (Foundation)
 |  | 4 | L201 | Politics (Foundation) | 4 | V102 | History (Foundation) | 4 | G451 | Web Development (Foundation) | 4 | L302 | Sociology (Foundation) | 4 | V102 | History (Foundation) | 4 | V102 | History (Foundation) | 4 | RRC4 | French and Spanish (Foundation) | 4 | V102 | History (Foundation)
 |  | 5 | P101 | Information Management (Foundation) | 5 | M102 | Economics (Foundation) | 5 | RRC4 | French and Spanish (Foundation) | 5 | G451 | Web Development (Foundation) | 5 | P101 | Information Management (Foundation) | 5 | G451 | Web Development (Foundation) | 4 | RRC4 | French and Spanish (Foundation) | 5 | RRC4 | French and Spanish (Foundation)
MMU Course Code | Course code | Course Title | 2008-09-01 00:00:00 | 2007-09-01 00:00:00 | DIFF | RANK | % Diff | RANK | 2008-10-01 00:00:00 | 2007-10-01 00:00:00 | DIFF | RANK | % Diff | RANK | 2008-11-01 00:00:00 | 2007-11-01 00:00:00 | DIFF | RANK | % Diff | RANK | 2008-12-01 00:00:00 | 2007-12-01 00:00:00 | DIFF | RANK | % Diff | RANK
400X | L115 | Business Economics (Foundation) | 0 | 3 | -3 | 14 | -1 | 14 | 0 | 5 | -5 |  | -1 | 15 | 0 | 2 |  |  | -1 | 16 | 0 | 2 |  |  | -1 | 13
404X | L114 | Business Economics (Foundation) | 38 | 9 | 29 | 3 | 3.222222222222222 | 2 | 30 | 26 | 4 |  | 0.1538461538461539 | 11 | 37 | 21 |  |  | 0.7619047619047619 | 5 | 25 | 4 |  |  | 5.25 | 2
401X | M102 | Economics (Foundation) | 13 | 5 | 8 | 5 | 1.6 | 3 | 16 | 7 | 9 |  | 1.285714285714286 | 4 | 15 | 8 |  |  | 0.875 | 4 | 10 | 7 |  |  | 0.4285714285714285 | 5
406X | L151 | Economics and Policy (Foundation) | 0 | 0 | 0 | 12 |  |  | 4 | 0 | 4 |  |  | 13 | 2 | 2 |  |  | 0 | 13 | 1 | 0
440X | RRC4 | French and Spanish (Foundation) | 12 | 6 | 6 | 6 | 1 | 4 | 14 | 11 | 3 |  | 0.2727272727272727 | 10 | 19 | 13 |  |  | 0.4615384615384616 | 7 | 3 | 10 |  |  | -0.7 | 10
440X | R101 | French Studies (Foundation) | 7 | 6 | 1 | 10 | 0.1666666666666667 | 10 | 8 | 5 | 3 |  | 0.6 | 7 | 8 | 5 |  |  | 0.6 | 6 | 1 | 10 |  |  | -0.9 | 12
410X | V102 | History (Foundation) | 4 | 16 | -12 | 16 | -0.75 | 13 | 25 | 18 | 7 |  | 0.3888888888888889 | 9 | 19 | 10 |  |  | 0.9 | 3 | 11 | 12 |  |  | -0.08333333333333333 | 8
462X | G564 | Information and Communications (Foundation) | 2 | 1 | 1 | 10 | 1 | 4 | 6 | 3 | 3 |  | 1 | 5 | 8 | 2 |  |  | 3 | 1 | 7 | 0
461X | P101 | Information Management (Foundation) | 18 | 14 | 4 | 7 | 0.2857142857142857 | 8 | 10 | 4 | 6 |  | 1.5 | 3 | 17 | 13 |  |  | 0.3076923076923077 | 9 | 1 | 4 |  |  | -0.75 | 11
4511 | M100 | Law | 1169 | 962 | 207 | 1 | 0.2151767151767152 | 9 | 1071 | 999 | 72 |  | 0.07207207207207207 | 12 | 915 | 902 |  |  | 0.01441241685144124 | 11 | 411 | 402 |  |  | 0.02238805970149254 | 7
451X | M101 | Law (Foundation) | 165 | 110 | 55 | 2 | 0.5 | 7 | 171 | 118 | 53 |  | 0.4491525423728814 | 8 | 171 | 170 |  |  | 0.005882352941176471 | 12 | 129 | 90 |  |  | 0.4333333333333333 | 4
471X | V501 | Philosophy (Foundation) | 6 | 7 | -1 | 13 | -0.1428571428571428 | 11 | 5 | 7 | -2 |  | -0.2857142857142857 | 14 | 5 | 4 |  |  | 0.25 | 10 | 6 | 5 |  |  | 0.2 | 6
470X | L201 | Politics (Foundation) | 23 | 5 | 18 | 4 | 3.6 | 1 | 14 | 2 | 12 |  | 6 | 1 | 8 | 9 |  |  | -0.1111111111111111 | 14 | 7 | 1 |  |  | 6 | 1
473X | L233 | Public Services (Foundation) | 3 | 0 | 3 | 9 |  |  | 3 | 1 | 2 |  | 2 | 2 | 3 | 4 |  |  | -0.25 | 15 | 0 | 0
424X | L302 | Sociology (Foundation) | 12 | 19 | -7 | 15 | -0.3684210526315789 | 12 | 12 | 6 | 6 |  | 1 | 5 | 16 | 11 |  |  | 0.4545454545454545 | 8 | 13 | 6 |  |  | 1.166666666666667 | 3
465X | G451 | Web Development (Foundation) | 10 | 6 | 4 | 7 | 0.6666666666666666 | 6 | 12 | 12 | 0 |  | 0 | 13 | 24 | 11 |  |  | 1.181818181818182 | 2 | 12 | 14 |  |  | -0.1428571428571428 | 9
 |  | Top 5 % DIFF | SEPTEMBER |  |  |  | OCTOBER |  |  |  | NOVEMBER |  |  |  | DECEMBER
 |  | 1 | L201 | Politics (Foundation) | 3.6 | 1 | L201 | Politics (Foundation) | 6 | 1 | G564 | Information and Communications (Foundation) | 3 | 1 | L201 | Politics (Foundation) | 6
 |  | 2 | L114 | Business Economics (Foundation) | 3.222222222222222 | 2 | L233 | Public Services (Foundation) | 2 | 2 | G451 | Web Development (Foundation) | 1.181818181818182 | 2 | L114 | Business Economics (Foundation) | 5.25
 |  | 3 | M102 | Economics (Foundation) | 1.6 | 3 | P101 | Information Management (Foundation) | 1.5 | 3 | V102 | History (Foundation) | 0.9 | 3 | L302 | Sociology (Foundation) | 1.166666666666667
 |  | 4 | RRC4 | French and Spanish (Foundation) | 1 | 4 | M102 | Economics (Foundation) | 1.285714285714286 | 4 | M102 | Economics (Foundation) | 0.875 | 4 | M101 | Law (Foundation) | 0.4333333333333333
 |  | 4 | G564 | Information and Communications (Foundation) | 1 | 5 | G564 | Information and Communications (Foundation) | 1 | 5 | L114 | Business Economics (Foundation) | 0.7619047619047619 | 5 | M102 | Economics (Foundation) | 0.4285714285714285
 |  | [NAME] DIFF
 |  | 14 |  |  |  | 15
 |  | 13 |  |  |  | 14
 |  | 12 |  |  |  | 13
 |  | 11 |  |  |  | 13
 |  | 10 |  |  |  | 12
 |  | Top 5 DIFF
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | Bottom 5 DIFF
 |  | 16
 |  | 15
 |  | 14
 |  | 13
 |  | 12