This Week's /r/Excel Recap for the week of May 09 - May 15, 2026
Our take
Welcome to this week’s recap of the /r/Excel community for May 9-15, 2026. Dive into the top discussions, including the clever use of the SWITCH function and thoughts on Excel skill levels. Unsolved posts highlight challenges with data management and Copilot integration, inviting shared insights. Notably, the community is also exploring unique applications of Excel, showcasing its versatility. For those facing Excel hurdles, check out our article, "Sort column B by another column A," for additional guidance on navigating complex data scenarios.
The recent recap from /r/Excel for the week of May 09 to May 15, 2026, provides a fascinating glimpse into the current conversations shaping the Excel community. Among the top discussions, the post titled “[Discussion] All You Need Is SWITCH” garnered significant attention, highlighting a growing interest in Excel’s functions that can simplify complex tasks. This reflects a broader trend where users are increasingly looking for innovative ways to enhance their spreadsheet capabilities, moving beyond traditional methods. Such discussions are vital, as they not only encourage user engagement but also empower individuals to explore the full potential of Excel, fostering a more efficient and productive environment.
Another notable topic was the inquiry about users’ self-assessed Excel skill levels. This conversation, captured in “[Discussion] When people ask you, what's your excel level? What would you say?” reveals the common struggle many face in evaluating their proficiency amidst a landscape of evolving tools and features. The comments section, filled with diverse responses, underscores how individuals gauge their abilities—often with a mix of humility and ambition. It’s a reminder that in the world of data management, self-awareness is crucial. As users become more familiar with functionalities like the SWITCH function, they also recognize areas for growth, allowing them to approach new tools with confidence and curiosity.
Unsolved posts, such as those regarding the removal of the copilot icon or issues with ODBC queries, point to the ongoing challenges users encounter when integrating advanced features into their workflows. These issues highlight a critical aspect of data management: while innovation is essential, user experience and seamless integration must remain a priority. The presence of such queries suggests that while many users are eager to adopt new technologies, there exists a gap between innovation and usability. Addressing this gap is not only crucial for user satisfaction but also for the continued evolution of spreadsheet technologies. As we see discussions around these topics, it's clear that product development teams must prioritize user feedback and adapt features to enhance accessibility and functionality.
The broader implications of these discussions cannot be overstated. They signify a shift towards a more human-centered approach in technology, where user outcomes take precedence over mere technical specifications. As seen in other areas, such as in articles like “Sort column B by another column A, except the column B has duplicated values, is missing values, and contains unexpected values,” the demand for solutions that simplify complex problems is growing. Users are not just looking for tools; they seek transformative solutions that empower their data journey. This evolution emphasizes the need for ongoing education and support within the community, ensuring that users feel equipped to tackle challenges as they arise.
Looking ahead, it will be intriguing to see how these conversations evolve and what new features or functions will emerge in response to user needs. As the landscape of data management continues to shift, will we see a greater emphasis on user-friendly innovations that prioritize accessibility and real-world applications? The future of Excel and similar tools lies in understanding the user experience and fostering an environment where exploration and discovery are not only encouraged but celebrated. The community’s engagement is a powerful reminder that effective data management is about more than just technology—it's about people and their ability to transform data into meaningful insights.
Saturday, May 09 - Friday, May 15, 2026
Top 5 Posts
| score | comments | title & link |
|---|---|---|
| 113 | 22 comments | [Discussion] All You Need Is SWITCH |
| 110 | 213 comments | [Discussion] When people ask you, what's your excel level? What would you say? |
| 95 | 56 comments | [unsolved] How to get the copilot icon off my spreadsheet? |
| 77 | 38 comments | [unsolved] New accounting job - massive databases in Excel! |
| 55 | 47 comments | [Discussion] What unusual thing do you use excel for |
Unsolved Posts
| score | comments | title & link |
|---|---|---|
| 12 | 8 comments | [unsolved] Pulling data from one sheet to another conditionally |
| 12 | 16 comments | [unsolved] Excel Crashes w/ ODBC Query After Copilot Integration |
| 9 | 15 comments | [unsolved] Expanding Sheets in Workbook |
| 9 | 13 comments | [unsolved] many to many relationship problem |
| 7 | 12 comments | [unsolved] Copying data from website to excel? |
Top 5 Comments
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- This Week's /r/Excel Recap for the week of April 18 - April 24, 2026Saturday, April 18 - Friday, April 24, 2026 Top 5 Posts score comments title & link 26 22 comments [solved] How to use AND and OR conditions within the same formula 18 15 comments [unsolved] Power Query Rounding Issue 13 21 comments [Waiting on OP] How to handle data from different sources when columns are in different orders? 6 5 comments [unsolved] Excel buffering while working between 2 workbooks 4 13 comments [unsolved] Vlookup on empy field with referece to line above Unsolved Posts score comments title & link 4 13 comments [unsolved] Calculating moving range in power query 4 16 comments [unsolved] how to record the exact time that I Click on a check box? and that the record will not change. 3 10 comments [unsolved] What formula(s) would I use to populate a cell depending on the info of an adjacent cell? 3 7 comments [unsolved] Automate copy from one worksheet to another using a cell reference 3 10 comments [unsolved] Generating a roll call based on recent meeting attendance Top 5 Comments score comment 637 /u/leostotch said The last time I asked copilot for Excel help, it made up an imaginary function. 208 /u/radek432 said When you perform the operation (0.9 - 0.6 - 0.3), Excel is actually dealing with tiny "remainders" created by the conversion to binary: 0.9 -> 0.89999999999999991118... 0.6 -> 0.59999999999... 165 /u/RoleNo3531 said =SUBSTITUTE(A1,"-","") 112 /u/Pestilence_XIV said To answer you question to be best of my knowledge, no. However, you could have them paste into an import sheet where formatting doesn’t matter, then you pull the data from that sheet into the one wi... 105 /u/icleanupdirtydirt said Nah. I've dabbled with copilot to do more complex things for me. It frequently seems to just pick the wrong reference cells even when explicitly told which to use. The formulas also just don't work ha... submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of March 07 - March 13, 2026Saturday, March 07 - Friday, March 13, 2026 Top 5 Posts score comments title & link 415 81 comments [Discussion] vlookup + curly brackets 134 123 comments [Discussion] What is the most complex spreadsheet you have ever created? 48 59 comments [solved] how to hide xlookup if there is nothing to look up 15 32 comments [unsolved] Cleaning up Excel → PowerPoint workflow for monthly management reports 14 10 comments [unsolved] Best way to share Office Scripts? Unsolved Posts score comments title & link 5 4 comments [unsolved] What is the best way to check if the file exists, is not open, and is a CSV file? 4 3 comments [unsolved] Extracting reports from a website based medical records system, refining the data, and consolidating it in a sheet 4 6 comments [unsolved] Calculating a date based on three criteria 3 1 comments [unsolved] Insert row that once data from column A to W is filled in, it moves the row down? I saw something about adding a button to manually make it shift with developer insert. That would be ok, but it seems like its conflicting with the columns I have as drop down options. 3 6 comments [unsolved] Excel's Data>From Web feature no longer pulling in financial data from SEC.gov's EDGAR. Top 5 Comments score comment 258 /u/smcutterco said A global medical nonprofit operating in third world countries was doing their local employee payroll in Excel with minimal data validation or data integrity controls. They had sixteen managers submitt... 221 /u/thisismyburnerac said wtf is this sorcery? I might actually stay until 5 today to try this out. 145 /u/redmera said Excel freelancing was highly oversaturated market even before generative AI. It's possible to make money on it, but it's extremely difficult given the competition. However, Excel as a skill is like a... 119 /u/Kooky_Outcome_5053 said You are on the right path, power query, power pivot, data modeling, M and DAX, power bi, python in excel. VBA not so much 86 /u/philsov said not easily. Could you just not make the "sum up the column" function on Row 1 and freeze there instead? Else you might want to run with Split window. submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of May 02 - May 08, 2026Saturday, May 02 - Friday, May 08, 2026 Top 5 Posts score comments title & link 321 26 comments [Discussion] Copying a cell in Excel spikes CPU to over 50% 267 186 comments [Discussion] Is excel still worth learning as a skill in 2026? 164 76 comments [Discussion] How many GB of RAM is required make a sheet with all cells filled? 29 28 comments [Discussion] Excel Test to Determine Skill 28 58 comments [unsolved] How to deal with a bulky spreadsheet that is starting to hit the limits of Excel? Unsolved Posts score comments title & link 27 16 comments [unsolved] How to disable new floating Copilot icon in all Excel windows? 5 5 comments [unsolved] Excel in page layout - How to remove pages without any content? 5 4 comments [unsolved] How to confront multiple sheets against each other? 4 9 comments [unsolved] How to make a drop down list based on static values of cells in column beside list 4 15 comments [unsolved] Formula to identify cells that may be a match to another cell in the same column. Not quite a duplicate. Top 5 Comments score comment 975 /u/Sinjazz1327 said Yes. The entire world runs on Excel. Even if you've got a software that replaces Excel, if you want it to talk to your own second software or your client's software you need Excel because the two a... 950 /u/MightyArd said No chance getting paid extra to make a spreadsheet for your current employer. Building it on your own time is likely relevant. You may get some internal kudos, but that's about it. 279 /u/Way-In-My-Brain said No multi national I've worked at is going to pay you for a spreadsheet you built in personal time to solve an in house problem. Not to mention I expect you're salaried and have a contract that covers ... 207 /u/ThorHammer1234 said A high school senior can do what you can with a simple AI prompt. Don’t double down, expand your skills. Launching an Excel course now is like buying a lottery ticket for a prize that was already draw... 186 /u/samspopguy said Yes to excel no to only excel submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of February 28 - March 06, 2026Saturday, February 28 - Friday, March 06, 2026 Top 5 Posts score comments title & link 12 10 comments [solved] Help calculating BMI percentiles using data set! 8 5 comments [Waiting on OP] Way to automate sending Excel screenshot to WhatsApp groups 7 9 comments [Waiting on OP] Scanning Barcodes on Excel 7 6 comments [Waiting on OP] Rearranging data syntax on a report 5 10 comments [unsolved] Need to know how to proceed with our company's service call excel sheet Unsolved Posts score comments title & link 5 6 comments [unsolved] Cant figure out bordersss! 4 12 comments [unsolved] Need to create a diagram of connected points 4 28 comments [unsolved] Creating a door access database 3 11 comments [unsolved] Excel Column Conditional Formatting 3 10 comments [unsolved] Automated pdf extraction into excel. Top 5 Comments score comment 408 /u/SolverMax said There's nothing wrong with adding a visual outline of a block of cells - provided the number of cells doesn't need to change, which would mess up the formatting. A Table structure is better for many ... 359 /u/bradland said Most of the people commenting here don't understand what you're asking. Excel has different types of protection. There's sheet level protection, workbook level protection, and file level encryption. T... 206 /u/shingfunger said I work as a consulting actuary and my colleagues and I use excel for hours a day. Everyone one I work with is comfortable with complex formulas, but honestly not that many use VBA or power query that ... 202 /u/SolverMax said I use both Python and Excel (including Power Query). They are different tools, suited to different things and different circumstances. One is not uniformly better than the other. Use whatever ... 166 /u/Informal-Freedom2558 said Ctrl + Shift + L to toggle filters on and off instantly… I use that way more than I thought I would. Also F4 to repeat the last action in Excel is lowkey elite, especially for formatting. And Alt + H ... submitted by /u/subredditsummarybot [link] [comments]