I have a workbook with 65,000 records on sheet 1 and 45,000 records on sheet 2. Each with 10 columns.
Column A has the Social Insurance Number of the client, and Column B has an account number.
The Social Insurance number is duplicated and in some cases triplicate and even quad, while the account number is unique for each record.
Is there a way to separate records with “one social account number and one account number” from the others, and then further separate the “one social Insurance number and 2 accounts” from those with “1 Social Insurance number and 3 accounts” etc.
Column A has the Social Insurance Number of the client, and Column B has an account number.
The Social Insurance number is duplicated and in some cases triplicate and even quad, while the account number is unique for each record.
Is there a way to separate records with “one social account number and one account number” from the others, and then further separate the “one social Insurance number and 2 accounts” from those with “1 Social Insurance number and 3 accounts” etc.