Spreadsheet: 102418d1300364573-excel-array-formula-offset-index-match-date-lookup
Sheet: Table

User | PlayedDates | Rating
Adam | 2010-09-22 00:14:24 | 112
[NAME] | 2010-09-22 00:14:24 | 100
Cris | 2010-09-28 00:14:24 | 52
[NAME] | 2010-10-03 00:28:48 | 151 |  | RowCount | 61
Ella | 2010-10-05 23:10:44 | 65
Fred | 2010-10-07 20:35:17 | 98 |  | Name | Entries | First date | Last Date | First Score | Last score | Matches |  | Re: Finding 2nd occurence and lookup value
[NAME] | 2010-10-08 10:02:30 | 117 |  | Adam | 12 | 2010-09-22 00:14:24 | 2011-01-12 09:22:58 | 112 | 116 | 0
Cris | 2010-10-08 10:16:47 | 62 |  | [NAME] | 8 | 2010-09-22 00:14:24 | 2010-12-13 23:51:18 | 100 | 151 | 0
Cris | 2010-10-15 10:32:15 | 54 |  | Cris | 8 | 2010-09-28 00:14:24 | 2011-01-12 16:22:17 | 52 | 160 | 0
Adam | 2010-10-15 11:16:07 | 121 |  | [NAME] | 8 | 2010-10-03 00:28:48 | 2011-01-12 09:24:52 | 151 | 154 | 0
Fred | 2010-10-15 11:20:08 | 99 |  | Ella | 8 | 2010-10-05 23:10:44 | 2011-01-12 09:20:29 | 65 | 132 | 0
Grif | 2010-10-16 09:23:43 | 94 |  | Fred | 8 | 2010-10-07 20:35:17 | 2011-01-12 11:28:36 | 98 | 101 | 0 |  | {=SUM(IF(MONTH(A2:A6)=B2,1))}
[NAME] | 2010-10-16 09:23:43 | 115 |  | Grif | 8 | 2010-10-16 09:23:43 | 2011-01-12 09:19:47 | 94 | 143 | 0
Fred | 2010-10-16 09:23:43 | 128 |  | Hank | 1 | 2011-01-14 18:51:05 | 2011-01-14 18:51:05 | 62 | 62 | 0
[NAME] | 2010-10-18 12:33:44 | 131 |  | - | - | - | - | - | - | -
[NAME] | 2010-10-18 16:28:53 | 113 |  | - | - | - | - | - | - | -
Adam | 2010-10-18 16:39:45 | 140 |  | - | - | - | - | - | - | -
Adam | 2010-10-18 17:48:57 | 116
Ella | 2010-10-31 15:43:09 | 103
[NAME] | 2010-10-31 18:50:05 | 118 |  | UnikDates | Entries | Adam | [NAME] | Cris | [NAME] | Ella | Fred | Grif | Hank | - | - | -
Fred | 2010-11-19 16:11:57 | 53 |  | 2010-09-22 00:00:00 | 2 | #N/A | ??
Adam | 2010-11-19 16:42:11 | 128 |  | 2010-09-28 00:00:00 | 1 |  |  | ?
[NAME] | 2010-11-19 17:25:03 | 78 |  | 2010-10-03 00:00:00 | 1
Cris | 2010-11-23 12:22:02 | 148 |  | 2010-10-05 00:00:00 | 1
[NAME] | 2010-11-23 12:23:52 | 125 |  | 2010-10-07 00:00:00 | 1
Cris | 2010-11-23 12:24:52 | 148 |  | 2010-10-08 00:00:00 | 2
Fred | 2010-11-23 12:26:07 | 68 |  | 2010-10-15 00:00:00 | 3
[NAME] | 2010-11-23 21:00:49 | 120 |  | 2010-10-16 00:00:00 | 3
Adam | 2010-11-23 21:02:46 | 118 |  | 2010-10-18 00:00:00 | 4
Grif | 2010-11-25 00:29:40 | 118 |  | 2010-10-31 00:00:00 | 2
Ella | 2010-11-25 00:31:14 | 123 |  | 2010-11-19 00:00:00 | 3
[NAME] | 2010-11-30 13:22:43 | 99 |  | 2010-11-23 00:00:00 | 6
Fred | 2010-11-30 13:33:08 | 118 |  | 2010-11-25 00:00:00 | 2
Fred | 2010-11-30 13:52:52 | 131 |  | 2010-11-30 00:00:00 | 4
Adam | 2010-11-30 14:39:24 | 101 |  | 2010-12-09 00:00:00 | 2
Ella | 2010-12-09 21:13:23 | 112 |  | 2010-12-13 00:00:00 | 5
[NAME] | 2010-12-09 21:14:28 | 148 |  | 2010-12-14 00:00:00 | 1
Ella | 2010-12-13 20:38:30 | 98 |  | 2010-12-23 00:00:00 | 2
Cris | 2010-12-13 20:39:14 | 117 |  | 2010-12-29 00:00:00 | 1
Grif | 2010-12-13 23:26:29 | 156 |  | 2010-12-31 00:00:00 | 3
Adam | 2010-12-13 23:49:33 | 138 |  | 2011-01-03 00:00:00 | 1
[NAME] | 2010-12-13 23:51:18 | 151 |  | 2011-01-04 00:00:00 | 2
Adam | 2010-12-14 01:07:39 | 181 |  | 2011-01-10 00:00:00 | 2
[NAME] | 2010-12-23 12:39:56 | 149 |  | 2011-01-12 00:00:00 | 6
Grif | 2010-12-23 12:41:48 | 130 |  | 2011-01-14 00:00:00 | 1
Cris | 2010-12-29 22:31:26 | 155 |  | #N/A | #N/A
Ella | 2010-12-31 00:00:00 | 156 |  | #N/A | #N/A
Grif | 2010-12-31 01:03:18 | 143 |  | #N/A | #N/A
Grif | 2010-12-31 17:39:53 | 154 |  | #N/A | #N/A
[NAME] | 2011-01-03 11:05:42 | 163 |  | #N/A | #N/A
Adam | 2011-01-04 10:13:43 | 116 |  | #N/A | #N/A
Adam | 2011-01-04 12:30:56 | 124 |  | #N/A | #N/A
Ella | 2011-01-10 10:39:45 | 134 |  | #N/A | #N/A
Grif | 2011-01-10 10:40:16 | 145 |  | #N/A | #N/A
Grif | 2011-01-12 09:19:47 | 143 |  | #N/A | #N/A
Ella | 2011-01-12 09:20:29 | 132 |  | #N/A | #N/A
Adam | 2011-01-12 09:22:58 | 116 |  | #N/A | #N/A
[NAME] | 2011-01-12 09:24:52 | 154 |  | #N/A | #N/A
Fred | 2011-01-12 11:28:36 | 101 |  | #N/A | #N/A
Cris | 2011-01-12 16:22:17 | 160 |  | #N/A | #N/A
Hank | 2011-01-14 18:51:05 | 62 |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 |  |  |  | #N/A | #N/A