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,
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,
Thank you, keep in mind sample data was just for concept, real data much more complicated, but ultimately concating date and phone is what worked, had to add extra column for date and outbound and column for date and inbound then Lookup value column to search concated out against concated inbound to avoid muliple calls outbound, then use distinct count of lookup column. I appreciate your insight.