•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 February 07 - February 13, 2026
Our take
In the week of February 07 to February 13, 2026, the /r/Excel community tackled pressing questions and shared valuable insights, addressing the challenges of legacy spreadsheet tools. Top discussions included users contemplating a switch from Microsoft Office and seeking best practices for managing large .xls files. Dive into this recap to discover practical solutions, from dynamic array lists to innovative workbook designs.
Saturday, February 07 - Friday, February 13, 2026
Top 5 Posts
| score | comments | title & link |
|---|---|---|
| 53 | 71 comments | [Discussion] Has anyone here tried switching away from Microsoft Office? |
| 25 | 43 comments | [unsolved] How yo diagnose is a .xls is "too big" or dosent follow best practices |
| 22 | 17 comments | [Waiting on OP] How would I make a workbook where the first sheet VSTACKS data from all subsequent sheets and then sorts them by column? |
| 19 | 27 comments | [Pro Tip] How to Split Strings and Join Values |
| 13 | 13 comments | [Waiting on OP] Replacing an xlookup with a better way? Database? |
Unsolved Posts
| score | comments | title & link |
|---|---|---|
| 10 | 18 comments | [unsolved] Assistance needed for Sage export - how to 'clean'? |
| 8 | 14 comments | [unsolved] IF/THEN formula with multiple conditions? |
| 6 | 2 comments | [unsolved] Better US heat maps? |
| 6 | 11 comments | [unsolved] Importing data from Excel to Word |
| 5 | 6 comments | [unsolved] Power Query with sticky manual columns. Is there a fix |
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 February 14 - February 20, 2026Saturday, February 14 - Friday, February 20, 2026 Top 5 Posts score comments title & link 9 12 comments [Waiting on OP] Turning a paragraph into excel data 7 19 comments [solved] Tools limited. How to automate multiple SQL server queries -> Excel workflow at work? 5 12 comments [Waiting on OP] BYROW with dynamic range, not working as expected? 5 12 comments [unsolved] Workbook from Microsoft Form encountering very long load times from excessive complex formulas 3 9 comments [unsolved] Conditional formulas when column groups are hidden? Unsolved Posts score comments title & link 2 0 comments [unsolved] Does advanced filtering work with sheetview? Top 5 Comments score comment 225 /u/loveLisega said formulas should definitely be protected by more than a color code. lock all cells that don't need user input and lock the sheet ! 202 /u/MayukhBhattacharya said My top recommendation before anything else, learn proper data structure first. Most beginners rush into formulas or Pivot Tables. But if the data is messy, everything feels harder than it should. Prop... 149 /u/soap_coals said Couldn't you use Sumifs() 123 /u/soap_coals said The only change for me has been to add additional steps to check for it and turn it off. It's also made me distrust documents produced by people who are new to the business. 109 /u/Parker4815-2 said Saves time. Chuck files in a folder. Hit refresh. Done. The problem is it takes time to setup and might go wrong a few times as steps are missed out (human error). That's when it gets hard to... submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of March 14 - March 20, 2026Saturday, 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 score comment 453 /u/MiteeThoR said INDEX(MATCH) gang rise up! There are DOZENS of us!  EDIT: HUNDREDS!!!! 209 /u/waltvark said Welcome to the team. And remember, we don’t tell coworkers how easy and quick we’ve made things, unless a raise/promotion is involved. 103 /u/smcutterco said In my experience, the best option is to ask the vendor to provide the invoices in Excel format or to provide a summary file with all of the invoice data. Vendor relationship managers are eager to add... 96 /u/rustyisherenow said Can’t tell you a specific laptop to get but for me most important is lots of RAM. Just got upgraded to 32GB of ram and it’s a whole lot better than the 8GB I had beforehand 90 /u/eiznekcmnnayllek said You should look into the Camera feature in excel. It's something you have to add to your toolbar by going to file > options > quick access toolbar > all commands > camera. Then select the area you wan... 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 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]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#no-code spreadsheet solutions#generative AI for data analysis#financial modeling with spreadsheets#big data management in spreadsheets#real-time data collaboration#natural language processing for spreadsheets#conversational data analysis#intelligent data visualization#rows.com#AI formula generation techniques#google sheets#Microsoft Office#.xls#workbook#VSTACKS#data validation#split strings#join values