Find date end for unique value.

Thank you both for help! I have a question to @Xlent:
According to screen, I should copy formula into D2 instead of C3, right? I did that and It's almost perfect, but, my fault sorry, I didn't show in example that Values can repeat in same Name range. That resulted in errors:
example2.png
Any way to fix this?

Originally Posted by Pojzon

...I have a question to @Xlent... I should copy formula into D2 instead of C3, right?

Yes, sorry about that.

...It's almost perfect, but, my fault sorry, I didn't show in example that Values can repeat in same Name range.... Any way to fix this?

Yes, minor change - highlighted in red below

=IF(OR(B2="";AND(A2=A1;B2=B1));"";IF(OR(A3<>A2;B3<>B2);C2;LOOKUP(2;1/(A3:A$29=A2)/(B3:B$29=B2)/(B2:B$28=B2);C3:C$29)))