=IF(SUMPRODUCT(-($B$8:$B$1000=B610),-($D$8:$D$1000="Active")),"Dup","")

does not work

It assigns "dup" to every order, except those companys that have no
active orders.




Bob Phillips wrote:
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.