•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 14 - February 20, 2026
Our take
As we navigate the evolving landscape of Excel, many users struggle with the limitations of legacy tools that hinder productivity. This week's /r/Excel recap highlights key discussions from February 14 to February 20, 2026, where users tackled pressing issues—from transforming paragraphs into data to automating SQL server queries. Dive into the top posts and comments that promise actionable insights and solutions, empowering you to enhance your Excel experience and drive greater efficiency in your workflows.
Saturday, 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
[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 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 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 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]
- 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]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#no-code spreadsheet solutions#generative AI for data analysis#real-time data collaboration#big data management in spreadsheets#conversational data analysis#intelligent data visualization#natural language processing for spreadsheets#business intelligence tools#financial modeling with spreadsheets#rows.com#self-service analytics tools#collaborative spreadsheet tools#Excel#formulas#data structure#SQL server#automation#conditional formulas