How to identify duplicates using two criteria

[Sean15]

Hello:

Excel 2010
	C	D	E	F	G
1	Name		Invoice No		Duplicate invoice
2	Peter Paul		121245		no
3	PeterPaul		121245		yes
4	Tiffany		5675225		yes
5	Macy		5675225		no
6	Tiffany		5675225		yes
7	PeterPaul		121245		yes
8	PeterPaul		1524456		No
Sheet1

If name in column C and Invoice No in column E appears more than once, required result in column G should be "duplicate", if not "no"
so in example above, Tiffany invoice No 5675225 appears more than once, so required value in column G should be "duplicate"
Macy invoice No 5675225 should be tagged "No" (even though it has same invoice no as Tiffany)

Could you help please?

Sean

 

[Fluff]

How about
=IF(COUNTIFS($A$2:$A$8,A2,$C$2:$C$8,C2)>1,"duplicate","no")

 

[Sean15]

Thank you very much.

Sean.

 

[Fluff]

You're welcome