If new

I have a worksheet as follows:

Year Customer
2009 A
2010 A
2015 A
2015 B
2011 C
2014 C
2010 D
2012 D


I want to create a formula (or use some other excel function) that tells me when I have a new customer.

I define new by saying they made their first purchase in 2014 or 2015 and didn't buy anything before that year.

Using the example above, customer B would be new because they made a purchase in 2015 with no earlier purchases however A & C both made purchase earlier than 2014 & D never made a purchase in 2014 or 2015. So A,C,D are not new but B is new.

I feel like this should be easy but I'm not able to write any formula that works.

Thanks!

How do I get column C to say New Customer is truly what I'm asking above.

I have way more than 9 rows and can't do it manually.

Sorry let me clarify ... your formula basically tells me anytime a new customer is listed for the first time.

I only want to identify customers with sales in 2014/2015 & only if they didn't have any prior sales

Thanks, that works!