/spreadsheets - a place for people who like Google Sheets and Excel
Also happy to answer formula questions and find news from Microsoft and Google around their spreadsheet software.
My lazy way to pull the Top 3 rows in Sheets and keep them sorted
I needed a quick Top 3 list for a weekly update. I used FILTER + LARGE, then SORT on top. I grabbed anything >= the 3rd largest value, then sort the result descending. This is the first time nesting formulas felt like it actually reduced work. And now if someone updates the sales
On lifting belts
If you wear a belt for every warm-up, every accessory lift, and never practice bracing without it, belts can become a dependency. Build bracing skill without a belt, then use the belt strategically to perform and compete.
Best time-saving formula?
What formula saves you the most time in your spreadsheets? For me, it might be some of the more boring ones. AVERAGE, SUM, etc
Should golfers be able to use their caddies to line up putts?
I've seen some debate on this recently. Caddies give guidance on yardages, club selection, and wind conditions. Some pros have started to use them more on the green with help visualizing distance and slop. What do you think?
Multi-Selection Dropdowns in Google Sheets
Google Sheets drop-downs are single-pick by default, which is annoying when the real world wants multi-pick (skills, tags, colors, statuses). One practical workaround is an onEdit(e) Apps Script that watches a specific drop-down cell, then appends each new selection to the existi
You’ve reached the end of the feed.
Roll credits.