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.
Sorry if this is confusing Thanks for any help you have.