Sorry, I meant that the count should be counted as greater thajn 1

=IF(SUMPRODUCT(--($A$1:L$A$20=$A1),--($B$1:$B$20="Active"))1,"Dup","")

If you just want to highlight the 2nd (and 3rd etc.) instance, then use

=IF(SUMPRODUCT(--($A$1:$A1=$A1),--($B$1:$B1="Active"))1,"Dup","")


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Bob Phillips" wrote in message
...
In column C

=IF(SUMPRODUCT(--($A$1:L$A$20=A1),--($B$1:$B$20="Active")),"Dup","")

and copy down

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Curious" wrote in message
oups.com...
2 Columns about order status

Company A expired
Company A expired
Company A active
Company A active
Company B active
Company C expired
Company D expired
Company D active
....
....

A company can have multiple expired orders but only one active order.
The purpose is to identify the company with multiple active orders and
fix it manually.

Thanks in advance.