find last cell contain specific text

[Yweiss0]

Hello Everyone,

so i have in my sheet a row with dates and another row with names,
the names are shown several times in different dates, I want to show in other place in the sheet (a few rows under..) the name and next to every name the last date it was written
so for example if Jim was written in 03/01/2017 and also in 21/05/2017 I want that a few rows under in the cell next to the name Jim I'll have only the date 21/05/2017

here an example..

[TABLE="width: 500"]
<tbody>[TR]
[TD]03/01/2017[/TD]
[TD]01/02/2017[/TD]
[TD]14/03/2017[/TD]
[TD]16/03/2017[/TD]
[TD]21/05/2017[/TD]
[TD]11/06/2017[/TD]
[TD]14/07/2017[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]David[/TD]
[TD]David[/TD]
[TD]Jhon[/TD]
[TD]Jim[/TD]
[TD]Alice[/TD]
[TD]Alice[/TD]
[/TR]
</tbody>[/TABLE]


and here (few rows under) I want to show like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]NAME[/TD]
[TD]LAST SEEN[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]21/05/2017[/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD]14/03/2017[/TD]
[/TR]
[TR]
[TD]Jhon[/TD]
[TD]16/03/2017[/TD]
[/TR]
[TR]
[TD]Alice[/TD]
[TD]14/07/2017[/TD]
[/TR]
</tbody>[/TABLE]


hope you can help me and thanks!

 

[Eric W]

Try this:

Excel 2012

	A	B	C	D	E	F	G

<tbody>
[TD="align: center"]1
[/TD]
[TD="bgcolor: #FFFFFF"]1/3/2017
[/TD]
[TD="bgcolor: #FFFFFF"]2/1/2017
[/TD]
[TD="bgcolor: #FFFFFF"]3/14/2017
[/TD]
[TD="bgcolor: #FFFFFF"]3/16/2017
[/TD]
[TD="bgcolor: #FFFFFF"]5/21/2017
[/TD]
[TD="bgcolor: #FFFFFF"]6/11/2017
[/TD]
[TD="bgcolor: #FFFFFF"]7/14/2017
[/TD]

[TD="align: center"]2
[/TD]
[TD="bgcolor: #FFFFFF"]Jim
[/TD]
[TD="bgcolor: #FFFFFF"]David
[/TD]
[TD="bgcolor: #FFFFFF"]David
[/TD]
[TD="bgcolor: #FFFFFF"]Jhon
[/TD]
[TD="bgcolor: #FFFFFF"]Jim
[/TD]
[TD="bgcolor: #FFFFFF"]Alice
[/TD]
[TD="bgcolor: #FFFFFF"]Alice
[/TD]

[TD="align: center"]3
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5
[/TD]
[TD="bgcolor: #FFFFFF"]NAME
[/TD]
[TD="bgcolor: #FFFFFF"]LAST SEEN
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6
[/TD]
[TD="bgcolor: #FFFFFF"]Jim
[/TD]
[TD="bgcolor: #FFFFFF"]5/21/2017
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7
[/TD]
[TD="bgcolor: #FFFFFF"]David
[/TD]
[TD="bgcolor: #FFFFFF"]3/14/2017
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8
[/TD]
[TD="bgcolor: #FFFFFF"]Jhon
[/TD]
[TD="bgcolor: #FFFFFF"]3/16/2017
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9
[/TD]
[TD="bgcolor: #FFFFFF"]Alice
[/TD]
[TD="bgcolor: #FFFFFF"]7/14/2017
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]
Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH="width: 10"]Cell
[/TH]
[TH="align: left"]Formula
[/TH]
[/TR]
[TR]
[TH="width: 10"]B6
[/TH]
[TD="align: left"]=LOOKUP(2,1/($A$2:$G$2=A6),$A$1:$G$1)
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


or

=IFERROR(LOOKUP(2,1/($A$2:$G$2=A6),$A$1:$G$1),"")

if you don't want the error message for no match. Make sure to format column B as Date.