Extract Unique lists in Excel - Including IF conditions

Поділитися
Вставка
  • Опубліковано 14 лис 2024

КОМЕНТАРІ • 11

  • @sandrakyoutube
    @sandrakyoutube 14 днів тому +1

    Very helpful. Thanks!💛

    • @datauntelligence
      @datauntelligence  14 днів тому

      So glad to hear that the video helped. Thanks for taking the time to write a message.

  • @unvunb7157
    @unvunb7157 3 місяці тому +1

    very good, thank you

    • @datauntelligence
      @datauntelligence  3 місяці тому +1

      No problem. Thanks for the comment. How often do you use excel?

    • @unvunb7157
      @unvunb7157 3 місяці тому

      @@datauntelligence very often, but I have an older version which does not support "unique".

    • @datauntelligence
      @datauntelligence  3 місяці тому +1

      Ah yes, Excel seems to update often. It's hard to keep up with what's new.

  • @stevereed5776
    @stevereed5776 3 місяці тому +3

    Why did you have to use the CHOOSECOLS Function? Is it not possible to have FILTER(B1:C149,D1:D149=""Mouse")

    • @datauntelligence
      @datauntelligence  3 місяці тому

      I love mixing and matching formula to find a solution I need. Great advice though to make the function even shorter.

  • @Dexter101x
    @Dexter101x 3 місяці тому +1

    Let me guess...you've been trying python in excel

    • @datauntelligence
      @datauntelligence  3 місяці тому +1

      Yeah, python in excel is a good addition. Have you tried it? What do you think?

    • @Dexter101x
      @Dexter101x 3 місяці тому

      @@datauntelligence I’ve only tried the basic things at the moment. It’s slightly different from what I’m used to