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.