Vertical space is at a premium, no sense in having lines with nothing but a single close paren. You don't want to drag down the formula bar and start hearing th

Vertical space is at a premium, no sense in having lines with nothing but a single close paren. You don't want to drag down the formula bar and start hearing the Star Wars title crawl music in your head. It's worth checking out the big alphabetical list of formulae, there's a lot of things that many people don't know are there. Look at the ones with the "Office 365" or "2019" labels for recently added ones (although annoyingly those are icons rather than text so you can't ctrl-f): https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188 https://support.microsoft.com/en-us/office/excel-functions-a... Also check out my other comment in this thread about tables if you don't already know what those are all about. And Powerquery too.