When repeat, is the order id the same or not? if not, how did you determine different order id is repeat purchase?
Can you also provide same sample data or sample workbook?
Order ID is not the same common identification is the email. So if the same email address appears twice, three times, four, five, six times within the same day with different order ID, it means that they did a repeat purchase within the same day.