•3 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 14 - March 20, 2026
Our take
Welcome to this week's recap of /r/Excel, covering the highlights from March 14 to March 20, 2026. Dive into the top discussions, including innovative solutions for automating data refreshes and strategies to handle large sheets that may cause crashes. Explore unresolved queries like efficient timekeeping methods and creating dynamic lists responsive to slicers. Additionally, don’t miss the most engaging comments from users sharing their insights and experiences. Join the conversation and empower your Excel journey by uncovering transformative solutions tailored to your needs.
Saturday, March 14 - Friday, March 20, 2026
Top 5 Posts
| score | comments | title & link |
|---|---|---|
| 33 | 16 comments | [Waiting on OP] Best way to automate data refresh for multiple power queries pulling from web sources? |
| 19 | 22 comments | [unsolved] Sheet is too big, laptop keeps crashing |
| 19 | 11 comments | [unsolved] How can I convert comma-separated numbers into a table automatically? |
| 13 | 22 comments | [solved] Trying to make my best fit line pass through the origin (0,0) |
| 12 | 15 comments | [Waiting on OP] Is there a way to convert a formula reference to text for sharing? |
Unsolved Posts
| score | comments | title & link |
|---|---|---|
| 8 | 19 comments | [unsolved] LF a simple way to have employees clock in and out (timekeeping) |
| 4 | 13 comments | [unsolved] Closest exact match formula? |
| 3 | 2 comments | [unsolved] Create a TopN list using Cubeset that responds to Slicers |
| 3 | 7 comments | [unsolved] Issue with transpose function when switching from sheets to excel |
| 3 | 15 comments | [unsolved] How do I return the date in which the column records the first date in which the column “chicken” has a value of “1”? |
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 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 March 21 - March 27, 2026Saturday, 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 score comment 503 /u/basejester said =FILTER(jobs[job name],jobs[allowsModernExcel]) 410 /u/randomcharacters3 said https://preview.redd.it/jzo7selzx6rg1.jpeg?width=553&format=pjpg&auto=webp&s=7c46b7f1d16a33d0a8ea967c1cf724c890857746 374 /u/rakshala said honestly, giving up and asking the internet for help has been the solution for me a few times. Not that the internet had the answer, but that the second I hit submit to publicize my stupidity, the ans... 365 /u/smcutterco said Power Query 235 /u/DarekKa said That XLOOKUP can return another XLOOKUP if #N/A is the result. i.e. XLOOKUP(Value, ARRAY1, ARRAY2, XLOOKUP(VALUE,ARRAY1, ARRAY3)). No need for IFERROR or other IFs 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]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#no-code spreadsheet solutions#generative AI for data analysis#natural language processing for spreadsheets#big data management in spreadsheets#big data performance#AI formula generation techniques#conversational data analysis#real-time data collaboration#financial modeling with spreadsheets#intelligent data visualization#data visualization tools#formula generator#enterprise data management#data analysis tools#data cleaning solutions#rows.com#google sheets