←Back to all posts
•2 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 April 11 - April 17, 2026

Saturday, April 11 - Friday, April 17, 2026

Top 5 Posts

score comments title & link
82 22 comments [Pro Tip] Get more from Power Query in Excel with these little-known capabilities
33 48 comments [solved] How to anonymize user names in a data set
16 17 comments [solved] Populate Cells From a Random Range of Cells, Based on the Contents of Different Cells.
12 8 comments [solved] Formula for vlookup + text or text + vlookup
9 11 comments [unsolved] Search Bar thats acts like a Slicer

 

Unsolved Posts

score comments title & link
3 7 comments [unsolved] Weird Excel double-decimal places

 

Top 5 Comments

score comment
81 /u/Normalitie said Try SUM(C.:.C) Note the periods before and after the colon, this causes Excel to omit blank rows above and below the data.
55 /u/bradland said This is good stuff for PQ in general, but I find it a bit odd that it is titled "Get more from Power Query in Excel" and then kicks off the conversation with Parameters. Parameters I almost ne...
53 /u/downtownjerm said Are the exports the same every time? It’s not pretty but you could set up a template with lookups to pull the data into a cleaner view. Then when you export the files just paste over the previous data...
32 /u/reggydavis said While the formats may vary bank to bank, each bank should be the same output every month. You’re going to need to build an individual power query for each bank in the format you want.
27 /u/AlgoDip said Guess you won’t be using it for much longer then

 

submitted by /u/subredditsummarybot
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#rows.com
#formula generator