Inactive/Closed Accounts in Spreadsheet

Here’s one way to do it: