Get only one Record with duplicated dates using sumproduct

[Absolution7]

Hello guys i need your help i want to get only 1 record with a multiple duplicates of dates but im always getting all the Training hours of a duplicate dates. How can i solve this can you please give me a sample formula using Sumproduct. Thanks!

 

[DanteAmor]

You can give an example of how you have the data and from them which one you want as a result.

 

[Absolution7]

You can give an example of how you have the data and from them which one you want as a result.

Trained Date Hours
1/1/2019 35
1/1/2019 15
1/1/2019 20
1/30/2019 10

I want to get the oldest record of hours any of the 35,15,20. I dont want to get all of the same date record, only just one

 

[DanteAmor]

Excel Workbook
	A	B	C	D	E
1	Trained Date	Hours		Date	Hours
2	01/01/2019	35		01/01/2019	35
3	01/01/2019	15		01/30/2019	10
4	01/01/2019	20
5	01/30/2019	10
6
Hoja1