Forum Discussion
Counting matching information inside the same table with multiple lines under each date
ePros ,
Here is one approach that uses Power Query.
1. Add a Custom Column and name it something like "Concat":
if [Outbound] = "" then [Date] & [Inbound] else [Date] & [Outbound]This will give you a column in which you will have your Duplicate values. Unable to describe the next steps in detail, but a google search for "Power Query find Duplicates" will give you the detailed steps you can follow to identify those records that have your Duplicate values.
Hope you can take it from this point on.
Regards,
Community ChampionePros ,
Here is one approach that uses Power Query.
1. Add a Custom Column and name it something like "Concat":
if [Outbound] = ""
then [Date] & [Inbound]
else [Date] & [Outbound]
This will give you a column in which you will have your Duplicate values. Unable to describe the next steps in detail, but a google search for "Power Query find Duplicates" will give you the detailed steps you can follow to identify those records that have your Duplicate values.
Hope you can take it from this point on.
Regards,
I like the thought process and I am sure it is the start, but actually if I made multiple outbound calls to the same number that day, it would show up like a match. But I will dig deep as my outbound and inbound are already added columns based on call type and disposition and I might be able to concat there and then match.
Thank you