• 9 Posts
  • 213 Comments
Joined 2 years ago
cake
Cake day: July 12th, 2023

help-circle











  • I must find the monstrous function which indexes 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.

    Edit: Here it is: ARRAYFORMULA(IFERROR((INDEX('Invoice History'!$A$7:$A$44, SMALL(IF(($G$3='Invoice History'!$D$7:$D$44)*('Invoice History'!$F$7:$F$44="Unpaid"), MATCH(ROW('Invoice History'!$A$7:$A$44), ROW('Invoice History'!$A$7:$A$44)), ""), ROW(A1))))))

    According to my documentation, it is used for “Looking up a value on a row, on another sheet, where two other values on that row match the given criteria”








  • I’m a meme archaeologist and I can confirm that in this context, it means that the written action occured spontaneously, without anybody asking for it, expecting it, or wanting it. Typical used to describe things that are rather strange or baffling. Such as:

    Nobody:

    Cats at 3am: “I must run so fast right now”

    For this meme, it’s implying that nobody really expected, wanted, or antagonized ol’ musky to become an evil corpo-oligarchic space Karen, but he did anyway, for seemingly no reason.