Was feeling a bit stuck on some spreadsheet janitorial work so asked ChatGPT. The formula it suggested didn't make sense to me as a long time spreadsheet user. But I tried it. And reader, it worked. Wild.