Spreadsheet: 154557d1336486157-how-to-lookup-highest-date-within-rows-with-duplicates-forum-test-
Sheet: Sheet1

customer ID | date-time | name | ZIP | town | adress | phone 1 | phone 2 | formula from example | here is where would be final result | YOUR COLUMN
301526117 | 2012-02-29 11:49:23 | \ELJKO BARICIC | 10000 | ZAGREB | NEGOVEÇKA 4 |  | 098417983 | 2012-02-29 11:49:23 | oldest or single entry | 29.2.2012 11:49:23
301526117 | 2012-02-15 13:29:25 | \ELJKO BARICIC | 10000 | ZAGREB | NEGOVEÇKA 4 |  | 098417983 | 2012-02-29 11:49:23 | NOT | 15.2.2012 13:29:25
300664893 | 2012-01-24 14:40:16 | [NAME] | 23210 | BIOGRAD N/M | J.J.STROSSMAYERA 19 |  | 023384124 | 2012-01-24 14:40:16 | oldest or single entry | 24.1.2012 14:40:16
302817937 | 2012-02-20 18:01:01 | [NAME] | 44400 | GLINA | VUKOVARSKA 9 | [PHONE] |  | 2012-02-20 18:01:01 | oldest or single entry | 20.2.2012 18:01:01
301443636 | 2012-01-25 11:01:12 | [NAME] | 32276 | BABINA GREDA | VL.NAZORA 8 |  | 098618647 | 2012-02-29 11:52:00 | NOT | 25.1.2012 11:01:12
301443636 | 2012-02-29 11:52:00 | [NAME] | 32276 | BABINA GREDA | VL.NAZORA 8 |  | 098618647 | 2012-02-29 11:52:00 | oldest or single entry | 29.2.2012 11:52:00
301292082 | 2012-02-14 15:36:48 | [NAME] | 31400 | đAKOVO | BOŽIDARA ADŽIJE 21 | [PHONE] |  | 2012-02-14 15:36:48 | oldest or single entry | 14.2.2012 15:36:48
302461199 | 2012-02-10 10:49:13 | [NAME] | 31511 | ĐURĐENOVAC | GORANA POTNEŠILA 34 | [PHONE] |  | 2012-02-10 10:49:13 | oldest or single entry | 10.2.2012 10:49:13
301433850 | 2012-01-24 12:57:29 | ADELA BIONDIĆ | 32254 | VRBANJA | JOSIPA KOZARCA 102 |  | 032863261 | 2012-01-24 12:57:29 | oldest or single entry | 24.1.2012 12:57:29
301331856 | 2012-01-25 11:04:15 | ADELA DRAGUN | 21260 | IMOTSKI | BIOKOVSKA 19 |  | 021843338 | 2012-01-25 11:04:15 | oldest or single entry | 25.1.2012 11:04:15
302868302 | 2012-02-07 12:55:12 | ADELA JUGOVIĆ | 22000 | [NAME] | NJEGOŠEV TRG 2A |  | 022338800 | 2012-02-27 12:44:00 | NOT | 7.2.2012 12:55:12
302868302 | 2012-02-23 13:16:21 | ADELA JUGOVIĆ | 22000 | [NAME] | NJEGOŠEV TRG 2A |  | 022338800 | 2012-02-27 12:44:00 | NOT | 23.2.2012 13:16:21
302868302 | 2012-02-24 17:33:17 | ADELA JUGOVIĆ | 22000 | [NAME] | NJEGOŠEV TRG 2A |  | 022338800 | 2012-02-27 12:44:00 | NOT | 24.2.2012 17:33:17
302868302 | 2012-02-27 12:44:00 | ADELA JUGOVIĆ | 22000 | [NAME] | NJEGOŠEV TRG 2A |  | 022338800 | 2012-02-27 12:44:00 | oldest or single entry | 2012-02-27 12:44:00
302826284 | 2012-02-29 11:52:42 | ADELA [NAME] | 47000 | KARLOVAC | BAKARSKA 8 | [PHONE] | 047412679 | 2012-02-29 11:52:42 | oldest or single entry | 29.2.2012 11:52:42
302826284 | 2012-01-30 18:44:12 | ADELA [NAME] | 47000 | KARLOVAC | BAKARSKA 8 | [PHONE] | 047412679 | 2012-02-29 11:52:42 | NOT | 30.1.2012 18:44:12
302819586 | 2012-02-15 19:24:02 | ADELA STOJANOVIĆ | 47250 | DUGA RESA | JOZEFINSKA 26 |  | 047844599 | 2012-02-24 12:44:21 | NOT | 15.2.2012 19:24:02
302819586 | 2012-02-24 12:44:21 | ADELA STOJANOVIĆ | 47250 | DUGA RESA | JOZEFINSKA 26 |  | 047844599 | 2012-02-24 12:44:21 | oldest or single entry | 24.2.2012 12:44:21
302901939 | 2012-01-30 12:06:07 | ADELA VEŠLIGAJ | 10430 | SAMOBOR | [NAME]. 20 |  | 013361961 | 2012-01-30 12:06:07 | oldest or single entry | 30.1.2012 12:06:07
301040960 | 2012-02-16 13:13:08 | [NAME] | 52465 | TAR | BORGO 35B |  | 052443419 | 2012-02-16 13:13:08 | oldest or single entry | 16.2.2012 13:13:08
302800818 | 2012-02-16 09:12:21 | [NAME] MILOŠEVIĆ | 35400 | NOVA GRADIŠKA | [NAME] 19 |  | 035365563 | 2012-02-16 09:12:21 | oldest or single entry | 16.2.2012 9:12:21