Hello everyone,
I have a personal project for my office where I need to analyze contacts from our customers, specially does who called us several times.
So, I've created a table with some fields (date, customer ID, contact ID, reason of the contact, concerned product) and filled it with ~285k rows that represents 1 month of customer contact.
As I have to analyze subcontractors, I'm only interested by the rows with a customer ID that repeats itself at least 2x in the whole column/field "customer ID" (in other words, I have to delete all "singles" contacts.
I've find many solutions to delete duplicate entries, but it goes in the opposite direction of my needs... somehow, I'd need a kind of filter on my table that would go like this : show only rows when the value in field Customer ID can be found at least 2x in the whole column/field Customer ID.
Does any of you have an idea how I should proceed to get this result ?
Create a Query of the table.
Click the "Totals" button, add the customer ID field 2 x
Under the second customer ID field change it from Group by to Sum
In the criteria field under the second Customer ID field enter >1
Hope this helps,
Dan
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the scales and adding to my reputation, Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks