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:

Date	Time	Person1	Person2	Person3	Person4	Person5
9/19/18	18:14	Joe Smith	Barb Smith	Lisa Loo	Sue Que	Kara Blue
9/18/18	18:37	Barb Smith	Joe Smith	Sue Que
9/18/18	18:13	Joe Smith	Kevin Loo	Sue Que	Lisa Loo
9/17/18	19:15	Barb Smith	Lisa Loo	Sue Que
9/17/18	18:50	Joe Smith	Mike Turner
9/14/18	18:46	Barb Smith	Sue Que
9/14/18	18:17	Joe Smith	Lisa Loo	Tim Church	Barb Smith	Sue Que
9/13/18	18:47	Barb Smith	Lisa Loo	Tim Church
9/13/18	18:19	Joe Smith
9/12/18	19:00	Lisa Loo	Mike Turner	Tim Church
9/12/18	18:40	Joe Smith	Mike Turner	Tim Church
9/11/18	19:03	Lisa Loo	Sue Que	Kara Blue
9/11/18	18:37	Joe Smith	Barb Smith	Sue Que	Kara Blue
9/10/18	19:02	Mike Turner	Tim Church
9/10/18	18:41	Lisa Loo	Mike Turner	Sue Que
9/7/18	18:40	Lisa Loo	Sue Que	Barb Smith
9/7/18	18:19	Lisa Loo	Joe Smith
9/6/18	18:53	Barb Smith	Tim Smith	Mike Turner
9/6/18	18:06	Joe Smith	Kara Blue
9/5/18	19:01	Lisa Loo	Kevin Loo
9/5/18	18:29	Joe Smith	Barb Smith	Kara Blue
9/4/18	18:14	Kara Blue	Barb Smith
9/4/18	17:41	Joe Smith
8/31/18	19:29	Barb Smith	Lisa Loo
8/31/18	19:01	Joe Smith	Mike Turner
8/30/18	19:19	Sue Que	Lisa Loo
8/30/18	18:30	Joe Smith	Kevin Loo	Sue Que	Lisa Loo
8/28/18	18:34	Kara Blue
8/28/18	18:13	Joe Smith	Kevin Loo	Lisa Loo	Tim Church
8/27/18	19:12	lisa Loo	Mike Turner
8/27/18	18:45	Joe Smith	Lisa Loo
8/24/18	19:18	Lisa Loo	Barb Smith	Tim Church	Joe Smith
8/24/18	18:51	Joe Smith	Tim Church

<colgroup><col width="87" span="7" style="width: 65pt;"></colgroup><tbody>
</tbody>

 

[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?