spreadsheets Community | Digg

@kites

13d

Superbowl Squares

Anybody using Google Sheets for superbowl squares this weekend?

@kites

24d

3 Ways to Count Colored Cells in Google Sheets

This guide explains how to count colored cells in Google Sheets using three methods: a custom script, a manual filter, or a third-party add-on. It provides detailed instructions and examples for each method.

@midi002

24d

You can download an updated CSV of all known Digg communities

File: tables.csv You can download historic data pulls, also. So if you really know what you're doing, you can make differential charts on growth of all communities, and the growth of each community by member count and post count.Courtesy of /digglist

@kites

24d

Excel: Workers cling to the software despite shift to AI

Despite efforts to centralize data control, many companies are still heavily reliant on Excel spreadsheets. Excel, a Microsoft product, has been in use for 40 years and is deeply embedded in business practices. However, tech leaders view it as an obstacle to more efficient digital workflows and AI. The persistence of Excel is partly due to its integration into technology education and its effectiveness for quick data analysis. However, its widespread use can lead to data management issues, as seen in the Health New Zealand financial performance case. Transitioning to more centralized data systems can lead to significant benefits, such as smoother workflows, cost savings, and improved data security.

@kites

27d

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

@kites

Jan 16th

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

@kites

Jan 15th

"Agent Mode" in Excel

Anyone using this regularly?

@kites

Jan 15th

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

@kites

11d

Between the sheets at the college Excel championships

This article explores the unique and fun world of college Excel championships, held in Las Vegas, where students compete in high-stakes spreadsheeting competitions. The event features individual and team challenges, with participants showcasing their Excel skills and strategies. The article highlights the dedication and competitive spirit of the students, as well as the growing recognition and support for this unusual college sport.