|First, you should read the How To referenced in my signature line to see how to post data so that it is easier for us to read:|
A B C D
NAME Parent Skill Child Skill DEPARTMENT
Joe System Admin Windows EIS
Joe System Admin Unix EIS
John App Dev C+ App
John App Dev COBOL App
Jim Networking Cisco EIG
Jim Networking Polycom EIG
Second, if you are using Pivot Tables, I can't help since I don't use them.
However, from a formula perspective, I can tell you this:
I don't think you can construct an Excel formula that checks for matching values in 2 columns but also checks to see if the corresponding cells in Column A are the same for more than one of those matches and then disregards all but one of them.
Excel formulas can't really do interative analysis like that. A User Defined Function written in VBA could probably do it, but no builit-in Excel function will do it without specifically checking the names. e.g. this will return 1, but it's only because we used Joe in the formula:
Posting Tip: Before posting Data or VBA Code, read this How-To.