Forum Discussion

kaymiah's avatar
kaymiah
Copper Contributor
Sep 20, 2021
Solved

Help with if text and auto identify team leaders

Hi I have a long list of names with many repeats due to the tasks they do. How can I auto populate the Column to show their team leaders? The two Coloums. Are Name and team leader. I have a lis...
excel
Formulas and Functions
  • Yea_So's avatar
    Yea_So
    Sep 21, 2021

    kaymiah 

     

    Here you go:

     

    File attached

kaymiah's avatar
kaymiah
Copper Contributor
Sep 21, 2021
Much appreciated. This looks brilliant.
Thanks.
For my reference is there a Tutorial on the code used or a link.
  • kaymiah's avatar
    kaymiah
    Copper Contributor
    Sep 22, 2021
    Thank you for clarification and changing the original template.
    Thank you again!
  • Yea_So's avatar
    Yea_So
    Bronze Contributor
    Sep 22, 2021

    kaymiah 

     

    there is nothing to see in this thread except dummy information if you bother to open the attachments

  • kaymiah's avatar
    kaymiah
    Copper Contributor
    Sep 22, 2021
    Sorry If I was not clear.
    Can you delete all the attachments please in the thread.
    Thank you.

Resources