Purfleet, in another sheet, I changed your formula to:
=IF(C2<>"","",IF(COUNTIFS($A$2:A2,A2)<COUNTIFS(Nam e,A2),"",IF(LARGE(--(Name=Registration!$A2)*(Date_of_Registration),1)> (YEAR(TODAY()),1,1),"NO","YES")))
I would like the formula in this instance to attach the NO or YES to the earliest date of registration not the latest. The column heading is "CURRENT" so either the answer is YES or NO. I tried to change the LARGE to SMALL but the result is the same with the LARGE function.
Thank you.