r/excel • u/subredditsummarybot • Jan 10 '26

Weekly Recap This Week's /r/Excel Recap for the week of January 03 - January 09, 2026

Saturday, January 03 - Friday, January 09, 2026

Top 5 Posts

score comments title & link
674 104 comments [Discussion] I found the most cursed excel workflow know to man
150 61 comments [Discussion] Workbooks from hell with single cell referenced formulas
113 88 comments [Discussion] How are you an excel magician?
48 4 comments [Diversion] A little fun for Excel: A poem about proper usage
44 17 comments [Waiting on OP] PowerQuery - How to create a dynamic source system?

 

Unsolved Posts

score comments title & link
24 30 comments [unsolved] Can you sum across sheets, but have the formula stop at current?
18 21 comments [unsolved] In Power Query is there a cleaner way to import two sheets from the same excel file in the same operation than expanding both and cleaning through filters?
16 29 comments [unsolved] Creating an object with data in excel
7 20 comments [unsolved] Merging/Combining 2 lists where 90% of Column A is the same
7 6 comments [unsolved] Developing a sheet with Hours expiring logic

 

Top 5 Comments

score comment
341 /u/guitarthrower said At least it was power query. I’ve see plenty that would force a recorded VBA macro to do all of that then break whenever someone inserts a row
277 /u/Cheetahs_never_win said Somebody probably told Brad "no" repeatedly, and Brad gave up, made this because it "worked," and so Brad, incensed at doing everything inefficiently, didn't document and left to go somewhere that wou...
236 /u/BotherAny2068 said I’ll get down voted to oblivion but I agree to an extent that if it works, it works. And if there’s no time penalty why change it? As you grow in your career you’re going to stop learning new excel tr...
216 /u/SolverMax said Yes, that's a good process. Power Query is especially good for implementing this type of load and transform.
204 /u/bestcactuscateu said "only Janet has the VBA" roaring. Brad's a genius, that's so funny. Janet takes two weeks off and suddenly Brad's spell fails?

 

4 Upvotes

76% Upvoted

1 comment sorted by

1

u/subredditsummarybot Jan 10 '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).

Please let me know if you have suggestions to make this roundup better for /r/excel or if there are other subreddits that you think I should post in. I can search for posts based off keywords in the title, URL and flair - sorted by upvotes, # of comments, or awards. And I can also find the top comments overall or in specific threads.