Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding multiple parent-child relationships?
I have a list of a bunch of people (employees) (column A) and in another
column (B), their managers. Each employee has a single record, but a manager name can show up multiple times. Not all employees are managers. I need to identify which managers are "front line" managers, e.g. who do not have any other managers reporting to them. I'd like to avoid going to VBA if this is possible to do in a formula. Basically, my logic needs to be: For every manager, check their direct reports to see if they also show up in the manager column. If none do, then flag this individual as a front line manager The problem I'm having is figuring out how to get a formula to process /every/ direct report. I'll need to use sumproduct or an array formula, but I'm still getting stuck on the logic. Let's say I copy column A to column C, just so I can do vlookups on either group. =sumproduct ((A1:A1000=ThisManager)*(vlookup(B1:B1000,B1:C1000 ,2,False).... but even here, I don't think the vlookup will necessarily be on the same row as the first parts of my sumproduct? Any ideas to get me started? Thanks! Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to display multiple children of a parent in excel | Excel Discussion (Misc queries) | |||
Retrieving info from "child" to a "parent" document | Excel Discussion (Misc queries) | |||
Windows browser Parent/Child structure | New Users to Excel | |||
Excel: How to import multiple XML "Repeating child elements" same. | Excel Worksheet Functions | |||
Sorting Parent Child | Excel Worksheet Functions |