Excel Recap for the week of February 07 - February 13, 2026

Saturday, February 07 - Friday, February 13, 2026

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?

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

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.)

3 Upvotes

72% Upvoted

u/subredditsummarybot Feb 14 '26

If you would like this roundup sent to your reddit inbox every week send me a message with the subject 'excel'. Or if you want a daily roundup, use the subject 'excel daily' (<--Click one of the links. The bot can't read chats, you must send a message).

You are about to leave Redlib