Trying to match several individuals to see how often and total times they have crossed paths

[Wenduff]

Hi. I've got a bunch of transactional data that I'm putting into Excel - dates, times, phone and people associated to each line item - kind of like traveling together is the best example I can give. I'm trying to match up the dates and times for Person A to see who Person A has strong relationships with - sometimes Person A contacts Person B, sometimes Person C, sometimes both at the same time. How do I look at records for up to 8 people to see if they have dates/times/calls in common to show that they have contact?

Sorry if this is confusing Thanks for any help you have.

 

[Peter_SSs]

Sorry if this is confusing

To me at least it is confusing.
I have no idea what you data actually looks like.
Any chance you could give us a small set of dummy data and the expected results?

 

[Wenduff]

Hi. Sorry. Yes, here's a sample of my data:
[TABLE="width: 609"]
<colgroup><col width="87" span="7" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: xl63, width: 87, align: center"]Date[/TD]
[TD="class: xl63, width: 87, align: center"]Time[/TD]
[TD="class: xl63, width: 87, align: center"]Person1[/TD]
[TD="class: xl64, width: 87, align: center"]Person2[/TD]
[TD="class: xl63, width: 87, align: center"]Person3[/TD]
[TD="class: xl63, width: 87, align: center"]Person4[/TD]
[TD="class: xl63, width: 87, align: center"]Person5[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/19/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:14[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"]Barb Smith[/TD]
[TD="class: xl65, width: 87"]Lisa Loo[/TD]
[TD="class: xl65, width: 87"]Sue Que[/TD]
[TD]Kara Blue[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/18/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:37[/TD]
[TD="class: xl65, width: 87"]Barb Smith[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"]Sue Que[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/18/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:13[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"]Kevin Loo[/TD]
[TD="class: xl65, width: 87"]Sue Que[/TD]
[TD]Lisa Loo[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/17/18[/TD]
[TD="class: xl67, width: 87, align: right"]19:15[/TD]
[TD="class: xl65, width: 87"]Barb Smith[/TD]
[TD="class: xl65, width: 87"]Lisa Loo[/TD]
[TD="class: xl65, width: 87"]Sue Que[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/17/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:50[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD]Mike Turner[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/14/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:46[/TD]
[TD="class: xl65, width: 87"]Barb Smith[/TD]
[TD]Sue Que[/TD]
[TD="class: xl65, width: 87"][/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/14/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:17[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD]Lisa Loo[/TD]
[TD="class: xl65, width: 87"]Tim Church[/TD]
[TD]Barb Smith[/TD]
[TD="class: xl65, width: 87"]Sue Que[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/13/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:47[/TD]
[TD]Barb Smith[/TD]
[TD]Lisa Loo[/TD]
[TD]Tim Church[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/13/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:19[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/12/18[/TD]
[TD="class: xl67, width: 87, align: right"]19:00[/TD]
[TD="class: xl65, width: 87"]Lisa Loo[/TD]
[TD="class: xl65, width: 87"]Mike Turner[/TD]
[TD="class: xl65, width: 87"]Tim Church[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/12/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:40[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"]Mike Turner[/TD]
[TD="class: xl65, width: 87"]Tim Church[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/11/18[/TD]
[TD="class: xl67, width: 87, align: right"]19:03[/TD]
[TD="class: xl65, width: 87"]Lisa Loo[/TD]
[TD="class: xl65, width: 87"]Sue Que[/TD]
[TD="class: xl65, width: 87"]Kara Blue[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/11/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:37[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"]Barb Smith[/TD]
[TD="class: xl65, width: 87"]Sue Que[/TD]
[TD="class: xl65, width: 87"]Kara Blue[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/10/18[/TD]
[TD="class: xl67, width: 87, align: right"]19:02[/TD]
[TD="class: xl65, width: 87"]Mike Turner[/TD]
[TD]Tim Church[/TD]
[TD][/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/10/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:41[/TD]
[TD="class: xl65, width: 87"]Lisa Loo[/TD]
[TD="class: xl65, width: 87"]Mike Turner[/TD]
[TD]Sue Que[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/7/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:40[/TD]
[TD="class: xl65, width: 87"]Lisa Loo[/TD]
[TD="class: xl65, width: 87"]Sue Que[/TD]
[TD]Barb Smith[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/7/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:19[/TD]
[TD="class: xl65, width: 87"]Lisa Loo[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/6/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:53[/TD]
[TD="class: xl65, width: 87"]Barb Smith[/TD]
[TD="class: xl65, width: 87"]Tim Smith[/TD]
[TD]Mike Turner[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/6/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:06[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"]Kara Blue[/TD]
[TD] [/TD]
[TD="class: xl65, width: 87"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/5/18[/TD]
[TD="class: xl67, width: 87, align: right"]19:01[/TD]
[TD="class: xl65, width: 87"]Lisa Loo[/TD]
[TD="class: xl65, width: 87"]Kevin Loo[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/5/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:29[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"]Barb Smith[/TD]
[TD="class: xl65, width: 87"]Kara Blue[/TD]
[TD="class: xl65, width: 87"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/4/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:14[/TD]
[TD]Kara Blue[/TD]
[TD="class: xl65, width: 87"]Barb Smith[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]9/4/18[/TD]
[TD="class: xl67, width: 87, align: right"]17:41[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]8/31/18[/TD]
[TD="class: xl67, width: 87, align: right"]19:29[/TD]
[TD="class: xl65, width: 87"]Barb Smith[/TD]
[TD]Lisa Loo[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]8/31/18[/TD]
[TD="class: xl67, width: 87, align: right"]19:01[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD]Mike Turner[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]8/30/18[/TD]
[TD="class: xl67, width: 87, align: right"]19:19[/TD]
[TD="class: xl65, width: 87"]Sue Que[/TD]
[TD]Lisa Loo[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]8/30/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:30[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"]Kevin Loo[/TD]
[TD="class: xl65, width: 87"]Sue Que[/TD]
[TD="class: xl65, width: 87"]Lisa Loo[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]8/28/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:34[/TD]
[TD="class: xl65, width: 87"]Kara Blue[/TD]
[TD] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]8/28/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:13[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"]Kevin Loo[/TD]
[TD]Lisa Loo[/TD]
[TD="class: xl65, width: 87"]Tim Church[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]8/27/18[/TD]
[TD="class: xl67, width: 87, align: right"]19:12[/TD]
[TD="class: xl65, width: 87"]lisa Loo[/TD]
[TD]Mike Turner[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]8/27/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:45[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD="class: xl65, width: 87"]Lisa Loo[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD="class: xl65, width: 87"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]8/24/18[/TD]
[TD="class: xl67, width: 87, align: right"]19:18[/TD]
[TD="class: xl65, width: 87"]Lisa Loo[/TD]
[TD="class: xl65, width: 87"]Barb Smith[/TD]
[TD="class: xl65, width: 87"]Tim Church[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 87, align: right"]8/24/18[/TD]
[TD="class: xl67, width: 87, align: right"]18:51[/TD]
[TD="class: xl65, width: 87"]Joe Smith[/TD]
[TD]Tim Church[/TD]
[TD="class: xl65, width: 87"] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Wenduff]

Just checking to see if I added my sample data correctly and that those with expertise can see to help?

 

[Fennek]

Hello, just an idea: arrange the list that each person is put in a specific column. Then use the autofilter. regards

 

[Peter_SSs]

Just checking to see if I added my sample data correctly ...

To me it looks like sample data, but appears to be missing ..

Any chance you could give us .... and the expected results?