Formula to select the earliest date

[exalex]

[TABLE="width: 197"]
<tbody>[TR]
[TD]
Person[/TD]
[TD]Date[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD="align: right"]2/21/2019[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD="align: right"]1/1/2018[/TD]
[TD="align: right"]85[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]Andy[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]Andy[/TD]
[TD="align: right"]4/1/2018[/TD]
[TD="align: right"]15[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]


I want a formula to pull the earliest date and amount for that per person:

Output: need formula for below Date and amount.
[TABLE="width: 197"]
<tbody>[TR]
[TD]Person[/TD]
[TD]Date[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD="align: right"]1/1/2018[/TD]
[TD="align: right"]85[/TD]
[/TR]
[TR]
[TD]Andy[/TD]
[TD="align: right"]4/1/2018[/TD]
[TD="align: right"]15[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]

 

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