Grabbing Last Data Entry

[DrunknMunky14]

Hi guys,

I'm trying to get the last entry of data from my database per person.

The database looks a little like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Person[/TD]
[TD]Date of Entry[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1/1/2014[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1/1/2014[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2/2/2014[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]3/3/2014
[/TD]
[/TR]
</tbody>[/TABLE]

On a different sheet I want column 2 to look like this:
[TABLE="width: 400"]
<tbody>[TR]
[TD]A[/TD]
[TD]2/2/2014[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]3/3/2014[/TD]
[/TR]
</tbody>[/TABLE]

Do I use a VLOOKUP, INDEX with SUMPRODUCT inside or something else completely?

 

[Weazel]

maybe something like,

Excel 2012

	A	B
a
b

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #FFFF00"]Person[/TD]
[TD="bgcolor: #FFFF00"]Date of Entry[/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: #FAFAFA"]A[/TD]
[TD="bgcolor: #FAFAFA, align: right"]1/1/2014[/TD]

[TD="align: center"]3[/TD]
[TD="bgcolor: #FAFAFA"]b[/TD]
[TD="bgcolor: #FAFAFA, align: right"]1/1/2014[/TD]

[TD="align: center"]4[/TD]
[TD="bgcolor: #FAFAFA"]a[/TD]
[TD="bgcolor: #FAFAFA, align: right"]2/2/2014[/TD]

[TD="align: center"]5[/TD]
[TD="bgcolor: #FAFAFA"]B[/TD]
[TD="bgcolor: #FAFAFA, align: right"]3/3/2014[/TD]

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

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

[TD="align: center"]8[/TD]

[TD="align: right"]2/2/2014[/TD]

[TD="align: center"]9[/TD]

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

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B8[/TH]
[TD="align: left"]=LOOKUP(2,1/(Sheet1!$A$2:$A$5=A8),Sheet1!$B$2:$B$5)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[DrunknMunky14]

Perfect, thank you!