2 min readfrom 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

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

score comment
71 /u/Downtown-Economics26 said Apologies, I missed the one cell part of it. You can make a dynamic array list with FILTER then reference that list in data validation. =FILTER(H2:H13,IF(A1="",I2:I13="",I2:I13=A1),""...
71 /u/0xhOd9MRwPdk0Xp3 said Probably cell validation with silent error but if I find out you are getting fired for sure
70 /u/pauloh1998 said Holy shit And here I thought making a Star Wars xwing game in Delphi was an accomplishment
64 /u/cookie_soft_57 said **Update: I am absolutely blown away by the response! 5k views and top 2 on the sub?! Thank you so much for the support and even the donations on itch.io. I'm heading back to my desk in 30 minutes and...
63 /u/Inevitable_Exam_2177 said Hey they only just added (decent) checkboxes, give em some time! (Honestly, this would be great. I’d also like to see a “star rating” interface type.)

 

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
#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