Formula to select the earliest date

[exalex]

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>

 

[Aladin Akyurek]

Book1
	A	B	C
1	Person	Date	Amount
2	Jim	2/21/2019	15
3	Jim	1/1/2018	85
4	Jim	4/6/2018	11
5	Andy	6/1/2019	23
6	Andy	4/1/2018	15
7
8
9	Person	Date	Amount
10	Jim	1/1/2018	85
11	Andy	4/1/2018	15
Sheet1

In B10 control+shift+enter, not just enter, and copy down:

=MIN(IF($A$2:$A$6=A10,$B$2:$B$6))

In C10 control+shift+enter, not just enter, and copy down:

=INDEX($C$2:$C$6,MATCH(A10,IF($B$2:$B$6=B10,$A$2:$A$6),0))

 

[exalex]

For some reason it is not working. any idea what the issue could be? Why control+shift+enter?

 

[Aladin Akyurek]

For some reason it is not working. any idea what the issue could be? Why control+shift+enter?

Because these are array-processing formulas...

Control+shift+enter: Press down the control and the shift keys while you hit the enter key. If done successfully, Excel itself puts a pair of { and } around the formula in recognition.