←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 May 16 - May 22, 2026

Saturday, May 16 - Friday, May 22, 2026

Top 5 Posts

score comments title & link
920 204 comments [Discussion] XLOOKUP replaced VLOOKUP for me and honestly I don't know why I waited so long
376 64 comments [Discussion] That 5-minute task in Excel
133 50 comments [solved] I have 400,000 lines I need to start at line 1 and label it Account1, line 2 would be Account2. Dragging takes 20 min. Any way to speed it up?
81 40 comments [unsolved] How to Unprotect Excel Workbook Without Password?
75 17 comments [Show and Tell] Showcase: QR code generator in Excel without macros, fonts, add-ins or internet access

 

Unsolved Posts

score comments title & link
19 18 comments [unsolved] How can I make dates correspond to annual events for a calendar, such as "Dec. 25th always equals Christmas"?
18 23 comments [unsolved] Excel and SharePoint together as a non-US person is hot garbage
15 30 comments [unsolved] Excel formatting things like "2-2" as date, then when reformatting to text it inserts a random number
14 16 comments [unsolved] Excel is not sorting "everything in Alphabetical order", when I go to Data and press sort it out from A-Z
11 11 comments [unsolved] Formulas that depend on sorted data, how to 'lock' them?

 

Top 5 Comments

score comment
487 /u/Strife_72 said XLOOKUP is like if HLOOKUP, VLOOKUP and IFERROR had a beautiful baby.
478 /u/ShootyMcFlompy said Double click the green box in the bottom right corner of your account numbering formula.
151 /u/BluebirdExpress6279 said Have you queried the Internet how to do this? You make a backup... then rename the .xlsx file to a .zip then open it and there is an xl folder containing all of your workseets. You remove out of the...
140 /u/Lazy_Helicopter_2659 said Still waiting for a replacement for INDEX ( MATCH () , MATCH () )
137 /u/Hot_Constant7824 said every 5 minute excel task somehow turns into a full forensic investigation 😭

 

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
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#formula generator
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#AI formula generation techniques
#XLOOKUP
#Excel