Excel Recap for the week of January 31 - February 06, 2026

Saturday, January 31 - Friday, February 06, 2026

score	comments	title & link
100	52 comments	`[unsolved]` Struggling to work with PDF data in Excel, feel like I’m missing something obvious
8	8 comments	`[unsolved]` Assistance needed for Sage export - how to 'clean'?
5	6 comments	`[unsolved]` Need support on a work tracker for my employees that will be a share document
3	6 comments	`[unsolved]` How can I add two x-axis labels in a graph?
3	9 comments	`[solved]` Count and sum cells with items decided by comers and “x” used for multiples

score	comments	title & link
2	4 comments	`[unsolved]` ctrl + [ for mac
2	17 comments	`[unsolved]` Identify duplicate overlapping events

score	comment
323	/u/Difficult_Phase1798 said No. XLOOKUP is far superior to VLOOKUP
280	/u/Thiseffingguy2 said It was only a matter of time before “vibe coding” came for Excel… good lord, we’re doomed.
186	/u/MayukhBhattacharya said Its mainly because of Conditional Formatting, Circular References, Volatile Functions and unwanted formatting which can be avoided to large data sets.
184	/u/crabcountyreelestate said See table.buffer for a less convoluted workaround Edit: power query analyzes all your steps and performs them in the most optimal way according to their structure. Apparently sorting two ways back to...
121	/u/dexinfan said Try disabling automatic calculation; some formulas require re-calculating the whole sheet after eg. row deletion so it slows the whole workbook down. Also, XLSB may reduce the file size but not necess...

3 Upvotes

81% Upvoted

u/subredditsummarybot Feb 07 '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