• fartsparkles@lemmy.world
      link
      fedilink
      arrow-up
      70
      ·
      3 months ago

      We need a /c/MuseumOfLemmy to preserve this treasure in so that it may be cherished and studied by our children and our children’s children and many generations beyond.

    • snooggums@lemmy.world
      link
      fedilink
      English
      arrow-up
      26
      ·
      3 months ago

      Year 7: Your team leader is gone after you pointed out he fucked up one of your sheets that run the business by merging a cell.

      I am laughing about how after 7 years nobody has locked the sheets that run the business to avoid this specific thing.

      Or maybe they were kocked and the team leader unlocked it so they could break it without saving a backup.

    • feannag@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      17
      ·
      3 months ago

      There’s no way they’re using xlookup at year 7. You can pry my index match from my cold dead hands.

      • xpinchx@lemmy.world
        link
        fedilink
        arrow-up
        7
        ·
        3 months ago

        Xlookup works fine for like 90% of cases, I save index match mainly for when I need to return multiple lookup values. In which case I load into BI because I always forget how index match works 😫

        • feannag@sh.itjust.works
          link
          fedilink
          English
          arrow-up
          6
          ·
          edit-2
          3 months ago

          I should probably learn how BI works, but I’m mostly torturing excel to do things it was never intended to do.

          Also I do a lot of lookups and xlookup will slow my sheet down.

          • xpinchx@lemmy.world
            link
            fedilink
            arrow-up
            3
            ·
            3 months ago

            Yeah if its something ad hoc I’ll paste values but for sheets meant to be maintained I’ll do it in PQ through merges or calculated columns. Lookups get the job done but they are expensive ;)

    • mmddmm@lemm.ee
      link
      fedilink
      arrow-up
      16
      ·
      3 months ago

      Why isn’t that “Merge Cells” button hidden behind 3 levels of menus up to this day?

    • BrowseMan@sh.itjust.works
      link
      fedilink
      arrow-up
      4
      ·
      edit-2
      3 months ago

      Damn as somebody with very little coding or IT background whatsoever but had to learn excel on my last 5 year of work, I understood it all.

      Especially the cell merging… Spawn of the devil itself…

      Still power query is quite addictive, the main reason why moving to OpenOffice is hard.

    • ink1ing@lemmy.world
      link
      fedilink
      arrow-up
      2
      ·
      3 months ago

      Just started a new job two weeks ago, all they use is Excel and Access. Now you’ve got me scared, first job out of uni and feels like a lot of pressure.