•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 January 31 - February 06, 2026
Our take
Navigating the complexities of Excel can often feel overwhelming, especially when dealing with challenges like PDF data integration or managing shared work trackers. This week's recap from /r/Excel shines a spotlight on the top community discussions, revealing common hurdles and innovative solutions. From debates over XLOOKUP versus VLOOKUP to tackling overlapping events, there's valuable insight waiting for you. Dive into these conversations to discover practical tips and strategies that can transform your Excel experience and help you work smarter, not harder.
Saturday, January 31 - Friday, February 06, 2026
Top 5 Posts
| 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 |
Unsolved Posts
| score | comments | title & link |
|---|---|---|
| 2 | 4 comments | [unsolved] ctrl + [ for mac |
| 2 | 17 comments | [unsolved] Identify duplicate overlapping events |
Top 5 Comments
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- This Week's /r/Excel Recap for the week of February 14 - February 20, 2026Saturday, February 14 - Friday, February 20, 2026 Top 5 Posts score comments title & link 9 12 comments [Waiting on OP] Turning a paragraph into excel data 7 19 comments [solved] Tools limited. How to automate multiple SQL server queries -> Excel workflow at work? 5 12 comments [Waiting on OP] BYROW with dynamic range, not working as expected? 5 12 comments [unsolved] Workbook from Microsoft Form encountering very long load times from excessive complex formulas 3 9 comments [unsolved] Conditional formulas when column groups are hidden? Unsolved Posts score comments title & link 2 0 comments [unsolved] Does advanced filtering work with sheetview? Top 5 Comments score comment 225 /u/loveLisega said formulas should definitely be protected by more than a color code. lock all cells that don't need user input and lock the sheet ! 202 /u/MayukhBhattacharya said My top recommendation before anything else, learn proper data structure first. Most beginners rush into formulas or Pivot Tables. But if the data is messy, everything feels harder than it should. Prop... 149 /u/soap_coals said Couldn't you use Sumifs() 123 /u/soap_coals said The only change for me has been to add additional steps to check for it and turn it off. It's also made me distrust documents produced by people who are new to the business. 109 /u/Parker4815-2 said Saves time. Chuck files in a folder. Hit refresh. Done. The problem is it takes time to setup and might go wrong a few times as steps are missed out (human error). That's when it gets hard to... submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of February 07 - February 13, 2026Saturday, 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]
- This Week's /r/Excel Recap for the week of March 21 - March 27, 2026Saturday, March 21 - Friday, March 27, 2026 Top 5 Posts score comments title & link 52 21 comments [unsolved] I have a power query in sharepoint that consolidates all a folder with many other excel files. How do i make it such that it refreshes automatically without opening it? 19 2 comments [Discussion] Excel supports nested arrays in cards / rich data field (A1.myArray) 15 19 comments [solved] Is there a better alternative to grouped rows? 12 18 comments [unsolved] Filter only select duplicates 7 8 comments [unsolved] I want to have the ability to track my workouts by recording results in a spreadsheet. Unsolved Posts score comments title & link 2 8 comments [unsolved] I am averaging multiple rows and not all rows have data. I want to apply that result to all rows. Picture attached. 2 8 comments [unsolved] Is there a formula to reverse-scored 2 9 comments [unsolved] Excel vba double checker 2 0 comments [unsolved] How to reset overlapping chart label positioning on each refresh / with slicer use? Top 5 Comments score comment 503 /u/basejester said =FILTER(jobs[job name],jobs[allowsModernExcel]) 410 /u/randomcharacters3 said https://preview.redd.it/jzo7selzx6rg1.jpeg?width=553&format=pjpg&auto=webp&s=7c46b7f1d16a33d0a8ea967c1cf724c890857746 374 /u/rakshala said honestly, giving up and asking the internet for help has been the solution for me a few times. Not that the internet had the answer, but that the second I hit submit to publicize my stupidity, the ans... 365 /u/smcutterco said Power Query 235 /u/DarekKa said That XLOOKUP can return another XLOOKUP if #N/A is the result. i.e. XLOOKUP(Value, ARRAY1, ARRAY2, XLOOKUP(VALUE,ARRAY1, ARRAY3)). No need for IFERROR or other IFs submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of March 07 - March 13, 2026Saturday, March 07 - Friday, March 13, 2026 Top 5 Posts score comments title & link 415 81 comments [Discussion] vlookup + curly brackets 134 123 comments [Discussion] What is the most complex spreadsheet you have ever created? 48 59 comments [solved] how to hide xlookup if there is nothing to look up 15 32 comments [unsolved] Cleaning up Excel → PowerPoint workflow for monthly management reports 14 10 comments [unsolved] Best way to share Office Scripts? Unsolved Posts score comments title & link 5 4 comments [unsolved] What is the best way to check if the file exists, is not open, and is a CSV file? 4 3 comments [unsolved] Extracting reports from a website based medical records system, refining the data, and consolidating it in a sheet 4 6 comments [unsolved] Calculating a date based on three criteria 3 1 comments [unsolved] Insert row that once data from column A to W is filled in, it moves the row down? I saw something about adding a button to manually make it shift with developer insert. That would be ok, but it seems like its conflicting with the columns I have as drop down options. 3 6 comments [unsolved] Excel's Data>From Web feature no longer pulling in financial data from SEC.gov's EDGAR. Top 5 Comments score comment 258 /u/smcutterco said A global medical nonprofit operating in third world countries was doing their local employee payroll in Excel with minimal data validation or data integrity controls. They had sixteen managers submitt... 221 /u/thisismyburnerac said wtf is this sorcery? I might actually stay until 5 today to try this out. 145 /u/redmera said Excel freelancing was highly oversaturated market even before generative AI. It's possible to make money on it, but it's extremely difficult given the competition. However, Excel as a skill is like a... 119 /u/Kooky_Outcome_5053 said You are on the right path, power query, power pivot, data modeling, M and DAX, power bi, python in excel. VBA not so much 86 /u/philsov said not easily. Could you just not make the "sum up the column" function on Row 1 and freeze there instead? Else you might want to run with Split window. submitted by /u/subredditsummarybot [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#generative AI for data analysis#no-code spreadsheet solutions#natural language processing for spreadsheets#real-time data collaboration#big data management in spreadsheets#conversational data analysis#financial modeling with spreadsheets#intelligent data visualization#rows.com#large dataset processing#row zero#Excel#PDF data#XLOOKUP#Sage export#VLOOKUP#work tracker#Count and sum cells