•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 February 28 - March 06, 2026
Our take
Welcome to this week’s recap of the /r/Excel community, highlighting the top discussions and insights from February 28 to March 6, 2026. This week featured a mix of solved queries, such as calculating BMI percentiles, alongside ongoing challenges like automating Excel screenshots to WhatsApp groups. Users engaged deeply with topics, reflecting the community's commitment to collaborative problem-solving. Dive into the top posts and comments to discover innovative solutions and practical tips that can enhance your spreadsheet skills and productivity.
Saturday, 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
[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 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 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]
- 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]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#no-code spreadsheet solutions#generative AI for data analysis#financial modeling with spreadsheets#natural language processing for spreadsheets#enterprise-level spreadsheet solutions#data visualization tools#data analysis tools#big data management in spreadsheets#self-service analytics tools#conversational data analysis#real-time data collaboration#intelligent data visualization#enterprise data management#big data performance#data cleaning solutions#rows.com#automated anomaly detection