• TempermentalAnomaly@lemmy.world
    link
    fedilink
    arrow-up
    2
    ·
    11 hours 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)
    
      • TempermentalAnomaly@lemmy.world
        link
        fedilink
        arrow-up
        2
        ·
        4 hours 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.