Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-20-2016, 12:55 PM
Lectorfiel Lectorfiel is offline Query to identify non-implicit relationship Windows 10 Query to identify non-implicit relationship Office 2013
Novice
Query to identify non-implicit relationship
 
Join Date: Feb 2016
Posts: 1
Lectorfiel is on a distinguished road
Default Query to identify non-implicit relationship

First of all thanks in advance for reading this post.

Recently, I am exploring Power Pivot and its multiple options and relations with Traditional pivot Tables.

I would like to know if this request can be resolve through a formula or query. I am looking to identify a relationship that is non Implicit. I will try to explain myself.

I am working with a file that has around 8.000 rows and 15 columns, my question is regarding to the first two columns.

Client and Counterpart. It is possible that Client has multiple Counterpart including itself. What I am looking for is identify those relations that are not explicit. This is a sample.
Client Counterpart
A C
B D
C D
A C
B E
C A
A B
B D
C D
A D
B B
C A
A D
B E
C A

Using a Pivot table I got the following table moving both Fields on Rows

Row Labels
A
B
C
D
B
B
D
E
C
A
D

What I need to get is the following List. I believe that maybe a query can be useful, but no idea how I can apply this on excel.

With whom Client is non related.

Client Counterpart
A A
E

B C

C B
C
E

I will appreciate any help in this matter.



Thank you again.

I hope hear from anyone soon.
Attached Files
File Type: xlsx Sample Query.xlsx (86.4 KB, 6 views)
Reply With Quote
Reply

Tags
pivot table, query, research

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query to identify non-implicit relationship Please help me Identify this font!!! PLEASE!!! krammkracker Word 1 10-13-2015 12:06 PM
Identify BookMark Location ptmuldoon Word VBA 4 12-14-2014 01:51 PM
Outlook 2010 on Windows 8 - Concern Over Contacts & Relationship with Exchange E-mail NormPhillips Outlook 0 02-02-2013 08:52 PM
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? mag Excel 0 10-18-2012 11:15 AM
Query to identify non-implicit relationship How to identify the paragraph number you are on SaneMan Word VBA 1 05-18-2011 05:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft