DrunknMunky14
New Member
- Joined
- Jun 4, 2014
- Messages
- 15
Hi guys,
I'm trying to get the last entry of data from my database per person.
The database looks a little like this:
<tbody>
</tbody>
On a different sheet I want column 2 to look like this:
<tbody>
</tbody>
Do I use a VLOOKUP, INDEX with SUMPRODUCT inside or something else completely?
I'm trying to get the last entry of data from my database per person.
The database looks a little like this:
Person | Date of Entry |
A | 1/1/2014 |
B | 1/1/2014 |
A | 2/2/2014 |
B | 3/3/2014 |
<tbody>
</tbody>
On a different sheet I want column 2 to look like this:
A | 2/2/2014 |
B | 3/3/2014 |
<tbody>
</tbody>
Do I use a VLOOKUP, INDEX with SUMPRODUCT inside or something else completely?