Person | Date | Amount |
Jim | 2/21/2019 | 15 |
Jim | 1/1/2018 | 85 |
Jim | 4/6/2018 | 11 |
Andy | 6/1/2019 | 23 |
Andy | 4/1/2018 | 15 |
<tbody>
</tbody><colgroup><col><col><col></colgroup>
I want a formula to pull the earliest date and amount for that per person:
Output: need formula for below Date and amount.
Person | Date | Amount |
Jim | 1/1/2018 | 85 |
Andy | 4/1/2018 | 15 |
<tbody>
</tbody><colgroup><col><col><col></colgroup>