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..

03/01/2017	01/02/2017	14/03/2017	16/03/2017	21/05/2017	11/06/2017	14/07/2017
Jim	David	David	Jhon	Jim	Alice	Alice

<tbody>
</tbody>

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

NAME	LAST SEEN
Jim	21/05/2017
David	14/03/2017
Jhon	16/03/2017
Alice	14/07/2017

<tbody>
</tbody>

hope you can help me and thanks!

 

[Eric W]

Try this:

Excel 2012

	A	B	C	D	E	F	G
1	1/3/2017	2/1/2017	3/14/2017	3/16/2017	5/21/2017	6/11/2017	7/14/2017
2	Jim	David	David	Jhon	Jim	Alice	Alice
3
4
5	NAME	LAST SEEN
6	Jim	5/21/2017
7	David	3/14/2017
8	Jhon	3/16/2017
9	Alice	7/14/2017
10

<tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula B6 =LOOKUP(2,1/($A$2:$G$2=A6),$A$1:$G$1) <tbody> </tbody>

<tbody>
</tbody>

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.