• saltesc@lemmy.world
    link
    fedilink
    arrow-up
    17
    arrow-down
    1
    ·
    edit-2
    19 hours ago

    Friend’s colleague needed Excel to, “return the month where the majority of days in the week fall into”. Had Copilot do it and sent it to my friend, apparently impressed by making such a robust looking formula.

    The formula:

    My friend’s solution a minute later:

    I can see it could be slimmed even less, but I assume the table is large so LET is doing performance stuff.

    • BilboBargains@lemmy.world
      link
      fedilink
      arrow-up
      10
      ·
      9 hours ago

      If you ask copilot to return a directory tree using MATLAB script it writes a function using a for loop and about 20 lines of code. Meanwhile the documentation defines this task as

      dir(“*”)