Multiple CountIf for Excel 2003

[sad8]

Hi,
I'm trying to use multiple COUNTIF functions but am using Excel 2003, so cannot use COUNTIFS
In the following chart, I am trying to come up with a formula to be able to mark in column C if this is a new pet that we're seeing. Perhaps there is something easier than COUNTIF, but I am failing with everything I try.

Pet​	Client​	​
Spot​	Jones​	New​
Bud​	Smith​	New​
Fluffy​	Harper​	New​
Spot​	Jones​	​
Bud​	Harper​	New​
Fluffy​	Jones​	New​
Bud​	Smith​	​

Any help would be appreciated! Thanks!







Thank you,

 

[jtakw]

Hi,

If I remember correctly, you should have SUMPRODUCT:

Book3.xlsx
	A	B	C
1	Pet	Client
2	Spot	Jones	New
3	Bud	Smith	New
4	Fluffy	Harper	New
5	Spot	Jones
6	Bud	Harper	New
7	Fluffy	Jones	New
8	Bud	Smith
Sheet969

Cell Formulas
Range	Formula
C2:C8	C2	=IF(SUMPRODUCT(--(A$2:A2&B$2:B2=A2&B2))=1,"New","")

 

[sad8]

That seems to work! Thank you so much! I've spent hours screwing around with this!

 

[jtakw]

You're welcome.