•3 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 March 07 - March 13, 2026
Our take
Welcome to this week's recap of /r/Excel for March 07 - March 13, 2026. This week featured engaging discussions and insightful problem-solving, with the top posts highlighting topics like VLOOKUP with curly brackets and the complexity of user-created spreadsheets. Join the conversation on unsolved challenges, including refining Excel to PowerPoint workflows and sharing Office Scripts. Dive into the community's insights and expertise to enhance your spreadsheet skills and discover innovative solutions for your Excel journey. Explore the top comments for added inspiration!
Saturday, 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
[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 April 18 - April 24, 2026Saturday, April 18 - Friday, April 24, 2026 Top 5 Posts score comments title & link 26 22 comments [solved] How to use AND and OR conditions within the same formula 18 15 comments [unsolved] Power Query Rounding Issue 13 21 comments [Waiting on OP] How to handle data from different sources when columns are in different orders? 6 5 comments [unsolved] Excel buffering while working between 2 workbooks 4 13 comments [unsolved] Vlookup on empy field with referece to line above Unsolved Posts score comments title & link 4 13 comments [unsolved] Calculating moving range in power query 4 16 comments [unsolved] how to record the exact time that I Click on a check box? and that the record will not change. 3 10 comments [unsolved] What formula(s) would I use to populate a cell depending on the info of an adjacent cell? 3 7 comments [unsolved] Automate copy from one worksheet to another using a cell reference 3 10 comments [unsolved] Generating a roll call based on recent meeting attendance Top 5 Comments score comment 637 /u/leostotch said The last time I asked copilot for Excel help, it made up an imaginary function. 208 /u/radek432 said When you perform the operation (0.9 - 0.6 - 0.3), Excel is actually dealing with tiny "remainders" created by the conversion to binary: 0.9 -> 0.89999999999999991118... 0.6 -> 0.59999999999... 165 /u/RoleNo3531 said =SUBSTITUTE(A1,"-","") 112 /u/Pestilence_XIV said To answer you question to be best of my knowledge, no. However, you could have them paste into an import sheet where formatting doesn’t matter, then you pull the data from that sheet into the one wi... 105 /u/icleanupdirtydirt said Nah. I've dabbled with copilot to do more complex things for me. It frequently seems to just pick the wrong reference cells even when explicitly told which to use. The formulas also just don't work ha... 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 April 11 - April 17, 2026Saturday, 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]
- This Week's /r/Excel Recap for the week of May 02 - May 08, 2026Saturday, May 02 - Friday, May 08, 2026 Top 5 Posts score comments title & link 321 26 comments [Discussion] Copying a cell in Excel spikes CPU to over 50% 267 186 comments [Discussion] Is excel still worth learning as a skill in 2026? 164 76 comments [Discussion] How many GB of RAM is required make a sheet with all cells filled? 29 28 comments [Discussion] Excel Test to Determine Skill 28 58 comments [unsolved] How to deal with a bulky spreadsheet that is starting to hit the limits of Excel? Unsolved Posts score comments title & link 27 16 comments [unsolved] How to disable new floating Copilot icon in all Excel windows? 5 5 comments [unsolved] Excel in page layout - How to remove pages without any content? 5 4 comments [unsolved] How to confront multiple sheets against each other? 4 9 comments [unsolved] How to make a drop down list based on static values of cells in column beside list 4 15 comments [unsolved] Formula to identify cells that may be a match to another cell in the same column. Not quite a duplicate. Top 5 Comments score comment 975 /u/Sinjazz1327 said Yes. The entire world runs on Excel. Even if you've got a software that replaces Excel, if you want it to talk to your own second software or your client's software you need Excel because the two a... 950 /u/MightyArd said No chance getting paid extra to make a spreadsheet for your current employer. Building it on your own time is likely relevant. You may get some internal kudos, but that's about it. 279 /u/Way-In-My-Brain said No multi national I've worked at is going to pay you for a spreadsheet you built in personal time to solve an in house problem. Not to mention I expect you're salaried and have a contract that covers ... 207 /u/ThorHammer1234 said A high school senior can do what you can with a simple AI prompt. Don’t double down, expand your skills. Launching an Excel course now is like buying a lottery ticket for a prize that was already draw... 186 /u/samspopguy said Yes to excel no to only excel submitted by /u/subredditsummarybot [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#no-code spreadsheet solutions#generative AI for data analysis#big data management in spreadsheets#enterprise data management#data cleaning solutions#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#big data performance#data analysis tools#financial modeling with spreadsheets#row zero#cloud-based spreadsheet applications#financial modeling#natural language processing for spreadsheets#rows.com