Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help needed.
I posted this question earlier but this is a simplified version of it.
In column A I have employees' names, in column B I have Team Leaers' names. Employee names will be unique in each cell but the team leaders names will be repeated several times. something like Employee TL John Robert Kelly Robert Michael Robert Gary Daniel Jerry Daniel Jim Robert Brian Robert Richie Kevin Pete Kevin Alex Daniel Now if I enter the Team Leader's name in another sheet's column A and drag it down, I want the names of the employees (only the ones in his team) to return in column B. Possible? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Min. Value is Needed | Excel Discussion (Misc queries) | |||
MVP needed | Excel Discussion (Misc queries) | |||
MVP HELP NEEDED ! | Excel Worksheet Functions | |||
help needed | Excel Discussion (Misc queries) | |||
Help needed please.. | Excel Discussion (Misc queries) |