Page 1 of 1
What's the most impressive spreadsheet function you've seen?
Posted: Fri December 20, 2024 2:36 am
by washing machine
There are some really wild ones out there. Hoping to learn some truly novel ones in this thread.
Re: What's the most impressive spreadsheet function you've s
Posted: Fri December 20, 2024 2:38 pm
by Bammer
Dropdown menus
Re: What's the most impressive spreadsheet function you've s
Posted: Fri December 20, 2024 2:43 pm
by 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
Re: What's the most impressive spreadsheet function you've s
Posted: Fri December 20, 2024 2:48 pm
by tragabigzanda
Naomi Klein wrote:"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."
Re: What's the most impressive spreadsheet function you've s
Posted: Fri December 20, 2024 3:47 pm
by 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.