Count new product in new year

[nhitong]

Hi all,

Really appreciated it if you guys can help me.

I want to count how many new products my company have in 2022. Below is an example of my data.

I have tried many calculations but have not yet identified the active one. 

Year	Product
2021	A
2021	B
2021	C
2021	D
2022	A
2022	B
2022	D
2022	E

The final result I want for this sample is one (in 2022 we have one new products "E")

Thank you so much,

[nhitong]

Thank you so muchhhhh

[CNENFRNL · Accepted solution]

Excel worksheet formula is powerful enough