Find duplicate names with a date >= to 6 years .

Hello all ,

i have a sheet that is 487,000 rows and approx 35,000 different horse names .
A horse with the same name may of raced in 2003 and 2019 , these two are not the same horse , only by name .

I just need to mark in col D with a X the horses that have a date >= to 6 years difference .
There are 3 i have changed to get my results . They are named .

A Beautiful Knight
A Girls Bestfriend
A Sherry For Mary

Horse names are in ascending order .

Hopefully this is pretty basic . ??? .

Thanks .

Thanks jindon your macro is perfect but i made a mistake in not asking the correct question properly .

I meant to ask if we look at cell C4 horse and date in cell B4 we have 20/10/2003 .
Cell B6 date is 1/01/2013 , this is the >= 6 years im looking for . These would be two different horses with same name .

A Girls Bestfriend ran between 2006 and 2009 , but theres another one with same name that ran in 2019 .

Thanks .

Thank you for your question .
There is no comparison to any other horse . Each and every horse is different .

What is happening is i have horse that raced in 2003 , example named Fred , he raced for 10 years to 2013 .
Another horse named Fred did not race with the same name .

A Beautiful Knight named horse ran twice in 2003 . Cells C4 and C5 .

In New Zealand you can name your horse A Beautiful Knight again but only after so many years . This is the difference in 6 years i am looking for .

So the horse named A Beautiful Knight did not run again until 2013 , cells B7 and C7 . making a difference of 6 years plus .

Its about the dates when they had there 1st run on a track officially . Then another horse with same name turns up but the date is 6 years after the previous ones same name last start .

Its like you have been here for 9 years and now another person comes in with your name , i want to separate you both but only if the second name appeared >= 6 years .

Thanks .

No , X is on row 6 , ID 5 cell A6 .

Its actually just taking one individual horse and looking at its last date of its last ever run or entry into my database and if then there is a gap of 6 years between the same named horse then mark with a X .

Irrelevant of date time , i can not have any horse with the same name , that would have two dates that would be over 6 years apart .

Meaning as slightly mentioned above , the last ever entry should not exceed >=6years to the next entry with a horse of the same name . Therefore they would imply my difference .

Yes jindon i can now see where i am confusing this . I have marked my results X in the wrong place .
I should be getting X result with explanation in this updated sheet . The 3 x sample horses should be correct now .

Apologies for mucking you around .
Thanks .

Absolutely perfect jindon . 100% .

I knew there may of been a few dozen with the same name but i didn't expect 200 x .
Bad stats is not good for my game so too have these accurate is great .

Thanks again for all your help and im putting a dollar away for you every time .
Thank you .