why not just try autofilter?

--


Gary


"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.