Getting only one record to a duplicated records

[Absolution7]

Hello guys i want to get only 1 record from a duplicated records because i have many duplicated dates i just need the oldest record, the formula im using is computing all the training hours for the whole month. Can someone help me with my formula Thanks!!

=SUMPRODUCT((MONTH('ABN CompletedTrainingListReport'!$A$3:$A$9000)=12)*('ABN CompletedTrainingListReport'!$F$3:$F$9000=$B74)*('ABN CompletedTrainingListReport'!$J$3:$J$9000))

 

[Col Delane]

Can you wrap the SUMPRODUCT argument which is giving you the matching dates (or add another argument) that returns TRUE for the MIN of the matching dates?