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 autho...
excel
Formulas and Functions
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?

      • pveiga's avatar
        pveiga
        Copper Contributor
        Jun 18, 2021
        aaa okey i didn't understand your question before. They have their own idAuthor and also the films so it wouln't be a problem.

        I'm using MS 365 for Business Version 2105

Resources