•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
This Week's /r/Excel Recap for the week of March 21 - March 27, 2026
Our take
Welcome to this week’s recap of /r/Excel for March 21 - March 27, 2026. Dive into the top discussions, including tips on automating Power Query refreshes in SharePoint and engaging debates about nested arrays and alternatives to grouped rows. Unsolved queries, like filtering duplicates and tracking workouts in spreadsheets, highlight the ongoing challenges users face. Explore the insightful comments that have sparked conversations, offering solutions and shared experiences within the Excel community. Join us as we navigate the latest trends and insights in Excel productivity!
Saturday, March 21 - Friday, March 27, 2026
Top 5 Posts
| score | comments | title & link |
|---|---|---|
| 52 | 21 comments | [unsolved] I have a power query in sharepoint that consolidates all a folder with many other excel files. How do i make it such that it refreshes automatically without opening it? |
| 19 | 2 comments | [Discussion] Excel supports nested arrays in cards / rich data field (A1.myArray) |
| 15 | 19 comments | [solved] Is there a better alternative to grouped rows? |
| 12 | 18 comments | [unsolved] Filter only select duplicates |
| 7 | 8 comments | [unsolved] I want to have the ability to track my workouts by recording results in a spreadsheet. |
Unsolved Posts
| score | comments | title & link |
|---|---|---|
| 2 | 8 comments | [unsolved] I am averaging multiple rows and not all rows have data. I want to apply that result to all rows. Picture attached. |
| 2 | 8 comments | [unsolved] Is there a formula to reverse-scored |
| 2 | 9 comments | [unsolved] Excel vba double checker |
| 2 | 0 comments | [unsolved] How to reset overlapping chart label positioning on each refresh / with slicer use? |
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 April 11 - April 17, 2026Saturday, April 11 - Friday, April 17, 2026 Top 5 Posts score comments title & link 82 22 comments [Pro Tip] Get more from Power Query in Excel with these little-known capabilities 33 48 comments [solved] How to anonymize user names in a data set 16 17 comments [solved] Populate Cells From a Random Range of Cells, Based on the Contents of Different Cells. 12 8 comments [solved] Formula for vlookup + text or text + vlookup 9 11 comments [unsolved] Search Bar thats acts like a Slicer Unsolved Posts score comments title & link 3 7 comments [unsolved] Weird Excel double-decimal places Top 5 Comments score comment 81 /u/Normalitie said Try SUM(C.:.C) Note the periods before and after the colon, this causes Excel to omit blank rows above and below the data. 55 /u/bradland said This is good stuff for PQ in general, but I find it a bit odd that it is titled "Get more from Power Query in Excel" and then kicks off the conversation with Parameters. Parameters I almost ne... 53 /u/downtownjerm said Are the exports the same every time? It’s not pretty but you could set up a template with lookups to pull the data into a cleaner view. Then when you export the files just paste over the previous data... 32 /u/reggydavis said While the formats may vary bank to bank, each bank should be the same output every month. You’re going to need to build an individual power query for each bank in the format you want. 27 /u/AlgoDip said Guess you won’t be using it for much longer then submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of April 04 - April 10, 2026Saturday, April 04 - Friday, April 10, 2026 Top 5 Posts score comments title & link 621 179 comments [Discussion] Why do "experts" insist that Excel is going to die when it is the most indestructible tool in the global economy? 16 17 comments [unsolved] auto send picture to whatsapp from excel 16 69 comments [unsolved] How to make a mathematical formula operate in the same cell in which I input a number? 15 8 comments [Waiting on OP] How to make Excel to stop seeing E as a scientific notation in a column 15 26 comments [unsolved] Database Spreadsheet and a separate Dashboard Unsolved Posts score comments title & link 10 13 comments [unsolved] Can I change data in one worksheet and have it change in all others 4 15 comments [unsolved] Daily account balance variance analysis 3 7 comments [unsolved] Combining Tables that feed from another data set 3 4 comments [unsolved] Trying to create a box and whisker (?) chart without the box. 3 13 comments [unsolved] how to consolidate a one date column, into multiple month columns? Top 5 Comments score comment 952 /u/SolverMax said Way more complex formulae get throw around on r/excel A complex formula is nothing to be proud of. Simplicity and understandability are much more important attributes for a formula. 728 /u/tothecatmobile said Because they're trying to sell the tool that's going to replace Excel (allegedly). 314 /u/JayHaz10 said Pressing decrease decimals when I wanted to increase decimals 291 /u/bradland said "Do not cite the old magic to me, Witch. I was there when it was written!" This formula is from the days before dynamic arrays. It uses some old IF broadcasting tricks to do things that we can do muc... 251 /u/VizNinja said We will always need a tool for individual analysis. Excel isn't going away submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of April 25 - May 01, 2026Saturday, April 25 - Friday, May 01, 2026 Top 5 Posts score comments title & link 9 11 comments [unsolved] How do I get slicers to work with a pivot table with multiple value tables, and also displayed in an easily legible way? 8 12 comments [unsolved] How Can I Move The Formula Bar? 2 17 comments [solved] Rounding my result that converts annual salary into an hourly rate by dividing by 2,080 hours 2 9 comments [solved] Formula for calculating regular and overtime hours based on a full week with an 8 hour day. 2 13 comments [unsolved] Use of text sequence formula vertically Unsolved Posts score comments title & link 2 8 comments [unsolved] Stop excel from jumping while scrolling Top 5 Comments score comment 333 /u/guy_incognito784 said Found the person who’s never had to scale a company before. If I’m the only one ingesting the info and a handful of other people and the company is small, sure this all works just fine. 172 /u/leostotch said I've had to do Excel assessments before (they're universally awful in my experience), but having to do one while somebody is watching? I promise, you don't want to see how the sausage gets ... 123 /u/Woosafb said The year was 2017 and I needed a way to unpivot columns. 113 /u/seventypercentcacao said you wont always be available to fix something when it breaks, imo using helper columns allow your colleagues to debug the formulas with much more ease 109 /u/FrankDrebinOnReddit said No freaking way. About half of my problems at work come from people using Excel for more than what it does well. That million rows limitation alone comes and goes quickly when you consider accounting ... submitted by /u/subredditsummarybot [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#no-code spreadsheet solutions#generative AI for data analysis#rows.com#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#real-time data collaboration#financial modeling with spreadsheets#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#AI formula generation techniques#modern spreadsheet innovations#machine learning in spreadsheet applications