Open Menu
AllLocalCommunitiesAbout
lotide
AllLocalCommunitiesAbout
Login

Found at work. Send help.

⁨93⁩ ⁨likes⁩

Submitted ⁨⁨1⁩ ⁨month⁩ ago⁩ by ⁨sunbrrnslapper@lemmy.world⁩ to ⁨[deleted]⁩

https://lemmy.world/pictrs/image/3271f61a-7c33-4dec-b612-698c1b1cddaa.png

source

Comments

Sort:hotnewtop
  • CaptainBasculin@lemmy.ml ⁨1⁩ ⁨month⁩ ago

    virgin =SUM() users vs chad click at each cell enjoyers

    source
    • LeFrog@discuss.tchncs.de ⁨1⁩ ⁨month⁩ ago

      What is even happening here? There is a sum of like every 13th cell?

      source
      • Enkers@sh.itjust.works ⁨1⁩ ⁨month⁩ ago

        My guess is that there are multiple tables on one sheet, and this is the summation of the sub-totals.

        source
        • -> View More Comments
      • fulcrummed@lemmy.world ⁨1⁩ ⁨month⁩ ago

        Every 13 cells could be summing the total of multiple years of data. Eg 12 month + 1 total, rinse and repeat. Then summing just the total cells for each year. 💁

        source
      • Aarkon@discuss.tchncs.de ⁨1⁩ ⁨month⁩ ago

        I guess this is Excel.

        source
  • rustyfemboy@lemmy.blahaj.zone ⁨1⁩ ⁨month⁩ ago

    Wait, that’s an actual formula. When I first saw this I thought it was an employee going insane and keysmashing into a spreadsheet as evidenced by the “send help”.

    source
    • sunbrrnslapper@lemmy.world ⁨1⁩ ⁨month⁩ ago

      Yup, actual formula. Might not even be the most offensive one in the spreadsheet.

      source
  • TempermentalAnomaly@lemmy.world ⁨1⁩ ⁨month⁩ ago

    Wait till AI is able to help.

    =TEXTJOIN("",TRUE,A330,A443,A556,A669,A782,A895,A1008,A1121,A1234,A1347,A1460,A1573,A1686,A1799,A2112,A2225,A2338,A2451,A2564,A2677,A2790,A3303,A3316,A3329,A3342,A3355,A3368,A3381,A3394,A5407,A5420,A5433,A5446,A5459,A5472,A5485,A5498,A5511,A5524,A5537,A5550,A5563,A5576,A5589,A5602,A5615,A5628,A5641,A5654,A5667)
    
    source
    • sunbrrnslapper@lemmy.world ⁨1⁩ ⁨month⁩ ago

      OMG. Which AI tool produced this?

      source
      • TempermentalAnomaly@lemmy.world ⁨1⁩ ⁨month⁩ ago

        Claude. To be fair, it had trouble OCR-ing it. After way too much back and forth about the pattern, it produced this:

        =LET(
            rows, SEQUENCE(INT((667-30)/13+1),1,30,13),
            SUM(INDEX(AA:AA,rows))
        )
        

        Which is correct, but obviously the calculations would be best served by reorganizing the table and probably using a pivot table or at least grouping and subtotaling.

        source
  • collapse_already@lemmy.ml ⁨1⁩ ⁨month⁩ ago

    Resume: “Experienced Excel Wizard”

    source
  • Agent641@lemmy.world ⁨1⁩ ⁨month⁩ ago

    I must find the monstrous function using virtual arrays that I implemented in a Google sheet of mine when I discovered there’s no limit to how reckless you can be in a single cell.

    source
  • Mic_Check_One_Two@reddthat.com ⁨1⁩ ⁨month⁩ ago

    I have written similarly awful formulae when I needed to get a csv to export to Google Calendars, but the program I was exporting to wasn’t using Google’s accepted csv headers.

    I ended up creating a template that looked at the exported csv file, and then reformatted it in a way that Google liked (and added some extra info along the way.) I needed it to only fill text if an entry actually had info in it, and hide all the text otherwise. So that I could automatically delete empty cells and avoid a bunch of empty calendar entries when importing it into Google. The resulting formula for some of the fields was… Not great. This is what controlled the “name” of each calendar event:

    Image

    It takes several different potential fields, and combines them into a single field. If there are no entries, it gets left blank.

    source
    • runner_g@lemmy.blahaj.zone ⁨1⁩ ⁨month⁩ ago

      Damn. At that point I would just switch over to a macro. Although I also have some formulas that xlookup a value, concatenate it, and the xlookup the new concatenated value.

      source
    • clay_pidgin@sh.itjust.works ⁨1⁩ ⁨month⁩ ago

      That’s bonkers but I can follow it, I think. Good work!

      source
  • Vegeta@lemmy.ca ⁨1⁩ ⁨month⁩ ago

    I winced.

    source