What's the most impressive spreadsheet function you've seen?

[washing machine]

There are some really wild ones out there. Hoping to learn some truly novel ones in this thread.

[Bammer]

Dropdown menus

[The Argonaut]

XLOOKUP has saved me hours of work on multiple occasions, allowed me to do things I never would've been able to do without it, and is sure to impress a friend or colleague. XLOOKUP is my absolute favorite

[tragabigzanda]

"Clout is the values-free currency of the always-online age — both a substitute for hard cash as well as a conduit to it. Clout is a calculus not of what you do, but of how much bulk you-ness there is in the world. You get clout by playing the victim. You get clout by victimizing others. This is something that is understood by the left and the right. If influence sways, clout squats, taking up space for its own sake."

[washing machine]

The most influential spreadsheet I ever worked with was a multi-tabbed beverage inventory sheet, complete with a rollup feature that connected to an overall COGS page.

This was like 10 years ago, but I still think about that sheet.