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

W

Wenduff

New Member
Joined
May 4, 2015
Messages
17
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.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
Wenduff said:
Sorry if this is confusing
Click to expand...
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?
 
Upvote 0
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]
 
Upvote 0
Just checking to see if I added my sample data correctly and that those with expertise can see to help?
 
Upvote 0
Hello, just an idea: arrange the list that each person is put in a specific column. Then use the autofilter. regards
 
Upvote 0
You must log in or register to reply here.

Similar threads

Sunline
  • Question Question
Find exact match, and the closest smallest and highest numbers.
Replies
3
Views
604
Sunline
Sunline
S
  • Question Question
A function similar to vlookup, but matching on partial values.
Replies
5
Views
632
etaf
etaf
sparky2205
  • Question Question
Work calendar to display several people
Replies
2
Views
642
sparky2205
sparky2205
MCLIFTO8
  • Question Question
Article / Guide feedback requested. The best way to learn Excel.
Replies
0
Views
1K
MCLIFTO8
MCLIFTO8
H
  • Question Question
Best way to show quantities and ratio on same chart?
Replies
2
Views
477
hmmmidk220
H

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top