I'd like your help, I've got a two-column excel, the first one containing the names of different group members, and the second one, the team leader who owns the person from the first column. I want in another sheet to bring the people to me for every team leader.
I hope I was understood
thank you.
Without a excel example I say:
Try a pivot table
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
i dont want with pivot. I tried with vlookup but brings me the same name. Any idea what can i do?
Upload a excelfile with what you have and what you want
here you are!
Try this formula in A2 'Member per Team leader'. Fill down and across column C until you get blanks.Formula:
Please Login or Register to view this content.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks