RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
Hi guys,
We have a sheet here with two data columns and thousands of rows. One is "Account number" and the other is "Username"
We want to find out where more than one username is using the same account number.
Currently what we are doing is filtering down to suspected Usernames, and then copying the Account Number, then removing filters and filtering down on the account number to see if more than 1 username appear.
Each row is another transaction, so where "Bob" withdraws to his account "1234" 3 times in a year he will have 3 rows.
So what I need to have is a formula that counts how many times "1234" appears and then I suppose counts on how many usernames belong to that account number.
We have a sheet here with two data columns and thousands of rows. One is "Account number" and the other is "Username"
We want to find out where more than one username is using the same account number.
Currently what we are doing is filtering down to suspected Usernames, and then copying the Account Number, then removing filters and filtering down on the account number to see if more than 1 username appear.
Each row is another transaction, so where "Bob" withdraws to his account "1234" 3 times in a year he will have 3 rows.
So what I need to have is a formula that counts how many times "1234" appears and then I suppose counts on how many usernames belong to that account number.