2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

This Week's /r/Excel Recap for the week of March 21 - March 27, 2026

Saturday, 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]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#no-code spreadsheet solutions
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#AI formula generation techniques
#modern spreadsheet innovations
#machine learning in spreadsheet applications