MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Records: 7  Duplicates: 0  Warnings: 0

Name	ID	Account
Nicole	01	12345
Nicole	01	67890
Alexis	02	67890
User01	01	99999
User02	02	99999
User02	02	99999
User03	03	99999

SELECT DISTINCT
       CASE WHEN t2.ID IS NULL 
            THEN t1.Name
            ELSE t2.Name
            END Name,
       CASE WHEN t2.ID IS NULL 
            THEN t1.ID
            ELSE t2.ID
            END ID,
       CASE WHEN t2.ID IS NULL 
            THEN t1.Account
            ELSE t2.Account
            END Account,
       CASE WHEN t2.ID IS NULL 
            THEN 'No'
            ELSE 'Yes'
            END Column_A,
       ( SELECT COUNT(t4.Account)
         FROM BankAccounts t4
         WHERE t1.Account = t4.Account ) NumberOfMatches,
       CASE WHEN t2.ID IS NULL 
            THEN CONCAT(t1.Name, ' (OK)')
            ELSE CONCAT(t1.Name, ' (BAD)')
            END Column_B,
       CASE WHEN t2.ID IS NULL 
            THEN NULL
            ELSE t1.ID
            END BadID
FROM BankAccounts t1
LEFT JOIN BankAccounts t2 ON t1.Account = t2.Account
                         AND t1.ID < t2.ID
LEFT JOIN BankAccounts t3 ON t1.Account = t3.Account
                         AND t1.ID > t3.ID
WHERE t3.ID IS NULL
ORDER BY Account, ID;

Name	ID	Account	Column_A	NumberOfMatches	Column_B	BadID
Nicole	01	12345	No	1	Nicole (OK)	null
Alexis	02	67890	Yes	2	Nicole (BAD)	01
User02	02	99999	Yes	4	User01 (BAD)	01
User03	03	99999	Yes	4	User01 (BAD)	01