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
      • pveiga's avatar
        pveiga
        Copper Contributor
        Jun 18, 2021
        In WIndows

Resources