List Unique Data referencing column C for Team and column B for Name

Hi Guys,

I need some help listing only name who are in Team A, Team B, Team C ETC.

I tried vlookup but it only brings back the first name of the match but not the unique name of everyone in the table/array

I have attached a sample below. If someone could help that will be greatly appreciated, Thanks

Sample.xlsx

Try using pivot table, drop Team Leader and Agent Name in the Row Fields area. You should see the structure show in the attached the file.

Thank you very much for your help benishiryo, your formula is exactly what ive been looking for, for the past year.

I was just wondering if you would be able to help me alter the formula to show the lists of Agents in the Team who are currently "Active" only.

Please find attached the sample below.

Sample.xlsx

Thank you

Re: List Unique Data referencing column C for Team and column B for Name
Thank you very much for your help benishiryo, your formula is exactly what ive been looking for, for the past year.

I was just wondering if you would be able to help me alter the formula to show the lists of Agents in the Team who are currently "Active" only.

Please find attached the sample below.

Sample.xlsx

Thank you

Thank you so much benishiryo for you help

It has made my job so much easier.

Thank you

@ arekkusu03

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.