←Back to all posts
•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 07 - March 13, 2026

Saturday, 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]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#no-code spreadsheet solutions
#generative AI for data analysis
#big data management in spreadsheets
#enterprise data management
#data cleaning solutions
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#big data performance
#data analysis tools
#financial modeling with spreadsheets
#row zero
#cloud-based spreadsheet applications
#financial modeling
#natural language processing for spreadsheets
#rows.com