Forum Discussion

pveiga's avatar
pveiga
Copper Contributor
Jun 18, 2021
Solved

Trying to find who is working with

Hello!! I have a table with different authors and films. 

 

Film            Author

Tenet          Peter

Lion King    Audrey

Tenet          Lucas

 

And so on..

 

I want to filter by the author in order to know who is he working with. For example, filter by Peter and the result shoul be Lucas in this case.

 

Thanks!!

excel
Formulas and Functions

10 Replies

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jun 18, 2021
    What should happen/is expected if theres's > 1 Peter exist in [Author]?
    • pveiga's avatar
      pveiga
      Copper Contributor
      Jun 18, 2021
      Good question. Actually the table has another column which is Profession so the same author may appear twice in the table as he has done two professions at the same film (screenwritter and director for example). I would also like it to appear but it`s not totally necessary.

      Thanks for your time
      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Jun 18, 2021

        pveiga 

        I'm afraid this doesn't help

         

        If we search on [Author] = Peter, which one should be picked?

        IMHO You should have 2 criterias: Author then Film

         

        BTW, what version of Excel do you run + Windows or Mac?

Resources