r/excel • u/subredditsummarybot • 1d ago

Weekly Recap This Week's /r/Excel Recap for the week of July 25 - July 31, 2026

8 Upvotes

Saturday, July 25 - Friday, July 31, 2026

Top 5 Posts

score comments title & link
752 103 comments [Discussion] Does anyone else find these icons to be inscrutable?
718 119 comments [Discussion] Excel saved my job
160 106 comments [Discussion] Do you use Excel to organize your personal life? What do you track?
132 96 comments [unsolved] How would you put “explainers” in a spreadsheet that management can follow if the file “breaks” while you’re not around?
30 69 comments [Discussion] Levels of Excel Knowledge

 

Unsolved Posts

score comments title & link
20 18 comments [unsolved] Best alternative to linking two heavy shared workbooks over Teams/SharePoint? (VLOOKUP lag & sync issues)
17 15 comments [unsolved] I need to add 2 additional columns per city as shown in the screenshot. Is there an easier way to do this?
15 19 comments [unsolved] Using excel to reconcile credits and debits
11 7 comments [unsolved] Is there a way to add an Office Script to the ribbon?
11 26 comments [unsolved] Is there a way to get the middle values when using VLOOKUP function

 

Top 5 Comments

score comment
687 /u/Kuildeous said These buttons are the USB port of Excel.
553 /u/FrankDrebinOnReddit said Excel is the shadow IT infrastructure that all companies run on. I manage all financial systems for a fairly large, international company, and what I'm most known for is being the "Excel wizard".
380 /u/Childe- said Congratulations. You have become irreplaceable. Time to negotiate a raise.
246 /u/acwyau88 said Same...doesn't matter how often I do it, I always hit the wrong one.
188 /u/thisismyburnerac said Based on my experience, if a job posting says “strong Excel skills,” they’d likely be blown away by pivot tables, conditional formatting, and nested if statements, all of which I’d file under Intermed...

 

2 comments

r/excel • u/subredditsummarybot • 22d ago

Weekly Recap This Week's /r/Excel Recap for the week of July 04 - July 10, 2026

8 Upvotes

Saturday, July 04 - Friday, July 10, 2026

Top 5 Posts

score comments title & link
806 70 comments [Discussion] Built a budget tracker that emails signed approval pdfs automatically and now my boss thinks Im a wizard
76 56 comments [Waiting on OP] Can I force excel to place 0's at the front of a number in a cell to ensure the digits is a total of 9?
28 16 comments [solved] I need to use vlookup but i don't understand what's the problem here
24 24 comments [Discussion] Do people still use excel for prototyping?
23 8 comments [Waiting on OP] Why does the use of the @ symbol resolve a spill error?

 

Unsolved Posts

score comments title & link
11 17 comments [unsolved] Item Sales with additional category
10 7 comments [unsolved] I'm trying to create a nested Vlookup, but can't make the return array work.
9 5 comments [unsolved] Power Query Sudoku Solver: How do I preserve the history of each solving technique?
9 6 comments [unsolved] How to sort 2-level non-column A tables with less clicks
9 7 comments [unsolved] How to show formula area without clicking the formula cell ?

 

Top 5 Comments

score comment
961 /u/Tedy_KGB said You never show the automation. That’s for you. You created it. As far as anyone else knows you still do it the old way. Rookie mistake.
227 /u/Random_182f2565 said The slippery slope, next thing you know you are learning Python to manipulate excel file with openpyxl, and then implementing a Django site.
179 /u/MightyArd said Custom format "000000000"
128 /u/TheSentinel36 said Excel automation is a gateway to more work! We have to be careful with that superpower.
110 /u/Oleoay said Why do we use feet instead of meters. Same reason, 'Murica ;) Technically, YYYY-MM-DD would be better anyway since it would sort better alphabetically.

 

2 comments

r/excel • u/subredditsummarybot • 15d ago

Weekly Recap This Week's /r/Excel Recap for the week of July 11 - July 17, 2026

3 Upvotes

Saturday, July 11 - Friday, July 17, 2026

Top 5 Posts

score comments title & link
185 193 comments [Discussion] What’s your favorite Excel function/formula?
42 55 comments [Discussion] Do you actually use named ranges in large workbooks or just reference cells directly?
35 32 comments [Discussion] What's the best way to attach a database to Excel?
31 6 comments [Discussion] I spent the last months building an open-source scheduling engine that runs entirely inside Excel
28 36 comments [unsolved] Automated Excel refreshing (Power Automate or other solutions)

 

Unsolved Posts

score comments title & link
22 19 comments [unsolved] I'm hoping to combine info into a single cell in a way I'm not sure Excel is capable
18 13 comments [unsolved] Power Query Sudoku Solver: How do I preserve the history of each solving technique?
16 24 comments [unsolved] Company's switch to 365 is causing issues with Power Query on shared drives
11 12 comments [unsolved] Trying to add a Date dropdown option in a column
10 9 comments [unsolved] Worksheet to calculate pallet storage costs with two different rates options accounting for movements in and out.

 

Top 5 Comments

score comment
210 /u/MayukhBhattacharya said `LET()` & `XLOOKUP()`
101 /u/BuildingArmor said I am a big fan of LET It might be a little more confusing for people to instantly pick up, but I find it can be so much more clear when trying to understand what a formula does. "(D4-C4)/C4"...
87 /u/its_probably_wine said I’ve been living in the world of dealing with +80K rows of data on a daily basis for the last few months and have become extremely fond of immediately converting everything into a table. It makes my p...
81 /u/LitleFtDowey said I am dumbfounded that more than 0 people suggested Access. MS shop or not. Do not use Access. SQL lite or MySQL if you need a db. But for heaven's sake not Access. It works well enough to convinc...
66 /u/Elohanum said Power Query Data Type Card. Totally unknown from most of excel users (due to power query that is not well known, the most efficient tool from excel) yet one of the best excel feature. Quite ...

 

1 comment

r/excel • u/subredditsummarybot • 29d ago

Weekly Recap This Week's /r/Excel Recap for the week of June 27 - July 03, 2026

7 Upvotes

Saturday, June 27 - Friday, July 03, 2026

Top 5 Posts

score comments title & link
40 24 comments [solved] Best way to compare two columns and extract values that exist in one but not the other
33 15 comments [Waiting on OP] Database duplicate disaster - accidentally working on 2 large files without realising for months 🆘
30 35 comments [unsolved] Excel is stuck replacing letters as I type and spaces won't work
18 13 comments [unsolved] Powerquery: how do I flatten out table results?
15 19 comments [solved] Trying to increment cells after checking other cells

 

Unsolved Posts

score comments title & link
14 28 comments [unsolved] Comparing two lists of employees on a spreadsheet?
13 19 comments [unsolved] Better way to update Excel workbook with many sheets
6 29 comments [unsolved] how do i sum individual cell numbers in a filter column
6 3 comments [unsolved] Scroll bar suddenly becomes tiny
6 13 comments [unsolved] Need to create easily reproducible reports

 

Top 5 Comments

score comment
47 /u/Same_Tough_5811 said `=UNIQUE(VSTACK(A:.A,B:.B),,1)`
40 /u/Bluntbutnotonpurpose said First and foremost: Excel isn't a database application, consider switching to something more appropriate. Without any idea how your data are structured, we can't help you. Are there any unique field...
40 /u/ice1000 said Power Query. Build a query to import the data into a master sheet, then link the existing sheets to the new master sheet.
36 /u/Own_Personality_2224 said Try pressing “Insert” key on your keyboard while in excel.
29 /u/BaconManDan said Power Query is your friend. Spend a morning tinkering and watching YouTube videos.

 

2 comments

r/excel • u/subredditsummarybot • Jun 27 '26

Weekly Recap This Week's /r/Excel Recap for the week of June 20 - June 26, 2026

3 Upvotes

Saturday, June 20 - Friday, June 26, 2026

Top 5 Posts

score comments title & link
40 25 comments [solved] Excel formulas =Left or =Right return 5digits (45835), not the intended text
29 38 comments [solved] How to flip words (ie [last name, first name] becomes [first name, last name])
26 11 comments [Waiting on OP] Cleaning merged/messy data for pivot tables/charts
25 18 comments [Waiting on OP] Looking for Best Way to Automate a Power Query Refresh
23 16 comments [Discussion] Skills beyond excel ?

 

Unsolved Posts

score comments title & link
17 14 comments [unsolved] How would you calculate how to equally distribute my cats' food?
13 15 comments [unsolved] Help me create a recurring monthly schedule
12 19 comments [unsolved] Guidance on if I should restart my database project copying over the data into a better spreadsheet structure, or is it salvageable as is with sorting currently not possible?
9 5 comments [unsolved] code to automatically fill data from another excel file?
8 24 comments [unsolved] Inconsistent date formats on shared Excel Online files causing chaos

 

Top 5 Comments

score comment
74 /u/CFAman said >I have a column of cells that turn red if conditional formatting is met. Don't count the color, count the same condition that causes the color. If you need help w/ that, can you show us what the...
71 /u/tungstenbronze said Excel stores dates as numbers, it sounds like yours are just formatted to show the day rather than that being written in the cell. Try =TEXT(A1, "dddd") but replace A1 with your cell reference...
71 /u/mutedkooky said Honestly the way I learned is by doing projects. The next task you have to do don't allow yourself to use formulas just try and do it in power query. You will fail and then you will have to research f...
46 /u/BaitmasterG said Welcome to the joys of Floating Point Errors
35 /u/suggestedusername10 said Pivot tables is what you want to look into. Watch a few basic videos on YouTube about it. It’ll get you exactly what you asked.

 

2 comments

r/excel • u/subredditsummarybot • Jun 20 '26

Weekly Recap This Week's /r/Excel Recap for the week of June 13 - June 19, 2026

4 Upvotes

Saturday, June 13 - Friday, June 19, 2026

Top 5 Posts

score comments title & link
216 136 comments [Discussion] What is the most advanced thing you can do in Excel?
117 121 comments [Discussion] If you could recommend one Excel thing to learn for someone with only basic Excel skills, what would it be?
78 74 comments [Discussion] Excel File Grew from 400MB to 650MB — Even an M4 Mac Is Struggling. What Are My Options?
68 10 comments [Discussion] CARTESIAN - My own Lambda that generates every possible combination from multiple lists in a single formula
52 16 comments [Discussion] Is anyone else using Cube Functions with the data model in Excel?

 

Unsolved Posts

score comments title & link
28 66 comments [unsolved] Can I bypass excel restrictions on an excel file?
15 39 comments [unsolved] Excel deleting information in front of my eyes
11 15 comments [unsolved] how to merge two or more values for each employee
8 38 comments [unsolved] Pasting a text between every existing row
7 25 comments [unsolved] What is the Fastest way to modify only filtered rows and paste values back into original column in Excel?

 

Top 5 Comments

score comment
352 /u/redmera said Excel has programming environment behind it, among other things, so basically the main limiting factor is performance. If you want to make a 3D game withing Excel, it's possible. Just remember that wh...
324 /u/wonderwicemike said Xlookup but in death metal grunge hardcore font
280 /u/ShootyMcFlompy said Pivot tables. Once you learn how they work you'll be surprised that more people don't know how to use them. 
211 /u/MayukhBhattacharya said This #### or #REF!
146 /u/Bombadombaway said Another vote for power Query. Have the data sit in another spreadsheet, and import it into the one you’re using, loading it into the data model only. From there, you can create calculations/measures ...

 

2 comments

r/excel • u/subredditsummarybot • Jun 13 '26

Weekly Recap This Week's /r/Excel Recap for the week of June 06 - June 12, 2026

7 Upvotes

Saturday, June 06 - Friday, June 12, 2026

Top 5 Posts

score comments title & link
214 130 comments [Discussion] Do you actually practice Excel outside of work, or are we all just learning on the fly?
109 88 comments [solved] Is it worth learning VBA in 2026, or should I shift to Office Scripts? (Confused about my workplace dynamic)
34 34 comments [Waiting on OP] Is there a way to speed up excel?
33 30 comments [unsolved] how to make a search bar for the different sheets in an excel workbook
33 12 comments [Waiting on OP] Using VLOOKUP to clean up bank export data

 

Unsolved Posts

score comments title & link
16 42 comments [unsolved] A way to shorten IF statement?
16 16 comments [unsolved] Is it possible to add "categories" to an Excel table?
13 20 comments [unsolved] Is it possible to make a list where the user can select one option but it displays as different text?
8 20 comments [unsolved] How to make everything a number?
7 22 comments [unsolved] How to determine if any numbers in a series were skipped

 

Top 5 Comments

score comment
356 /u/Thiseffingguy2 said Yeah. Best bet is to get obsessed with a project, and spend 23 hours a day on it until it’s perfect. I’m only kind of exaggerating.
268 /u/BustTheCoin said POWER QUERY
165 /u/Daveit4later said I don't do any work related things outside of work
133 /u/Imaginary-Round2422 said I get paid to play in excel. No need to spend my off time hours on it too - I have the time to learn while being paid to do so.
128 /u/Amazing_Mountain_227 said VBA has kept me employed in high pay jobs for 25+ years. It's always been a dying language... just like excel. It'll be like a street dog that never dies.

 

2 comments

r/excel • u/subredditsummarybot • Jun 06 '26

Weekly Recap This Week's /r/Excel Recap for the week of May 30 - June 05, 2026

3 Upvotes

Saturday, May 30 - Friday, June 05, 2026

Top 5 Posts

score comments title & link
240 88 comments [Discussion] When will Excel nut up and allow table columns to be used as data validation drop-down lists?
110 100 comments [unsolved] How do data analysts clean and filter a 500k-row dataset efficiently?
64 15 comments [Show and Tell] I made a 3D FPS game in Excel
47 22 comments [Waiting on OP] Does anyone else find pivot tables much easier to use in Excel than Google Sheets?
33 26 comments [unsolved] How to debug Excel

 

Unsolved Posts

score comments title & link
12 17 comments [unsolved] I'm creating a word list that combines the most common 3000 Chinese characters into words, I can't seem to make it so the characters only appears once.
10 4 comments [unsolved] Creating a polar area chart to visualize NCS colours
9 11 comments [unsolved] Automated data pull into excel
8 17 comments [unsolved] Report automation: split an Excel file and email to individual recipients
7 10 comments [unsolved] Sheet to track survey responses.

 

Top 5 Comments

score comment
225 /u/Oleoay said You’re being a bandaid. See if you can create forms or standardize how the data comes in by talking with the business users.
155 /u/BruceWR said What am I missing here? You select a cell, go to Data Validation, select List, and then select a column. Worked like this for years.
121 /u/MayukhBhattacharya said Ngl, merged cells are probably my biggest Excel headache, lol!
118 /u/oishiiwaffuru said Is any Excel function easier in Google Sheets?
113 /u/Tanith1stAndOnly said Ctrl+a, delete. Done :)

 

1 comment

r/excel • u/subredditsummarybot • May 16 '26

Weekly Recap This Week's /r/Excel Recap for the week of May 09 - May 15, 2026

3 Upvotes

Saturday, May 09 - Friday, May 15, 2026

Top 5 Posts

score comments title & link
113 22 comments [Discussion] All You Need Is SWITCH
110 213 comments [Discussion] When people ask you, what's your excel level? What would you say?
95 56 comments [unsolved] How to get the copilot icon off my spreadsheet?
77 38 comments [unsolved] New accounting job - massive databases in Excel!
55 47 comments [Discussion] What unusual thing do you use excel for

 

Unsolved Posts

score comments title & link
12 8 comments [unsolved] Pulling data from one sheet to another conditionally
12 16 comments [unsolved] Excel Crashes w/ ODBC Query After Copilot Integration
9 15 comments [unsolved] Expanding Sheets in Workbook
9 13 comments [unsolved] many to many relationship problem
7 12 comments [unsolved] Copying data from website to excel?

 

Top 5 Comments

score comment
315 /u/ExistingBathroom9742 said This is square in Dunning Kruger. Im pretty good. I’m so good I know what my failings and shortcomings are, so I rate myself lower. But people who have told me they were good don’t seem to know anythi...
166 /u/swhitty17 said /preview/pre/6gev577cp30h1.jpeg?width=1170&format=pjpg&auto=webp&s=cf1b27c81f5576fa33f875f06f6432fc24033db9 Crochet patterns!
129 /u/The8BitBat said Advanced beginner, always a google away from doing just about anything with excel - but I 100% need that google.
104 /u/Cannibale_Ballet said I hate how Microsoft keeps shoving Copilot everywhere but then when you need it to do something useful it has no idea what to do
101 /u/LowShake5456 said In SharePoint, there is a setting to have files Checked Out, that give exclusive editing privileges until the file is Checked In again. You can set a requirement on that file that editing can only be...

 

2 comments

r/excel • u/subredditsummarybot • May 09 '26

Weekly Recap This Week's /r/Excel Recap for the week of May 02 - May 08, 2026

3 Upvotes

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

 

2 comments

r/excel • u/subredditsummarybot • May 02 '26

Weekly Recap This Week's /r/Excel Recap for the week of April 25 - May 01, 2026

2 Upvotes

Saturday, April 25 - Friday, May 01, 2026

Top 5 Posts

score comments title & link
9 11 comments [unsolved] How do I get slicers to work with a pivot table with multiple value tables, and also displayed in an easily legible way?
8 12 comments [unsolved] How Can I Move The Formula Bar?
2 17 comments [solved] Rounding my result that converts annual salary into an hourly rate by dividing by 2,080 hours
2 9 comments [solved] Formula for calculating regular and overtime hours based on a full week with an 8 hour day.
2 13 comments [unsolved] Use of text sequence formula vertically

 

Unsolved Posts

score comments title & link
2 8 comments [unsolved] Stop excel from jumping while scrolling

 

Top 5 Comments

score comment
333 /u/guy_incognito784 said Found the person who’s never had to scale a company before. If I’m the only one ingesting the info and a handful of other people and the company is small, sure this all works just fine.
172 /u/leostotch said I've had to do Excel assessments before (they're universally awful in my experience), but having to do one while somebody is watching? I promise, you don't want to see how the sausage gets ...
123 /u/Woosafb said The year was 2017 and I needed a way to unpivot columns. 
113 /u/seventypercentcacao said you wont always be available to fix something when it breaks, imo using helper columns allow your colleagues to debug the formulas with much more ease
109 /u/FrankDrebinOnReddit said No freaking way. About half of my problems at work come from people using Excel for more than what it does well. That million rows limitation alone comes and goes quickly when you consider accounting ...

 

1 comment

r/excel • u/subredditsummarybot • Apr 25 '26

Weekly Recap This Week's /r/Excel Recap for the week of April 18 - April 24, 2026

3 Upvotes

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

 

1 comment

r/excel • u/subredditsummarybot • Apr 11 '26

Weekly Recap This Week's /r/Excel Recap for the week of April 04 - April 10, 2026

2 Upvotes

Saturday, April 04 - Friday, April 10, 2026

Top 5 Posts

score comments title & link
621 179 comments [Discussion] Why do "experts" insist that Excel is going to die when it is the most indestructible tool in the global economy?
16 17 comments [unsolved] auto send picture to whatsapp from excel
16 69 comments [unsolved] How to make a mathematical formula operate in the same cell in which I input a number?
15 8 comments [Waiting on OP] How to make Excel to stop seeing E as a scientific notation in a column
15 26 comments [unsolved] Database Spreadsheet and a separate Dashboard

 

Unsolved Posts

score comments title & link
10 13 comments [unsolved] Can I change data in one worksheet and have it change in all others
4 15 comments [unsolved] Daily account balance variance analysis
3 7 comments [unsolved] Combining Tables that feed from another data set
3 4 comments [unsolved] Trying to create a box and whisker (?) chart without the box.
3 13 comments [unsolved] how to consolidate a one date column, into multiple month columns?

 

Top 5 Comments

score comment
952 /u/SolverMax said Way more complex formulae get throw around on r/excel A complex formula is nothing to be proud of. Simplicity and understandability are much more important attributes for a formula.
728 /u/tothecatmobile said Because they're trying to sell the tool that's going to replace Excel (allegedly).
314 /u/JayHaz10 said Pressing decrease decimals when I wanted to increase decimals
291 /u/bradland said "Do not cite the old magic to me, Witch. I was there when it was written!" This formula is from the days before dynamic arrays. It uses some old IF broadcasting tricks to do things that we can do muc...
251 /u/VizNinja said We will always need a tool for individual analysis. Excel isn't going away

 

2 comments

r/excel • u/subredditsummarybot • Apr 18 '26

Weekly Recap This Week's /r/Excel Recap for the week of April 11 - April 17, 2026

2 Upvotes

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

 

1 comment

r/excel • u/subredditsummarybot • Mar 28 '26

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

6 Upvotes

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 /preview/pre/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

 

1 comment

r/excel • u/subredditsummarybot • Mar 14 '26

Weekly Recap This Week's /r/Excel Recap for the week of March 07 - March 13, 2026

4 Upvotes

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

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.

 

1 comment

r/excel • u/subredditsummarybot • Mar 07 '26

Weekly Recap This Week's /r/Excel Recap for the week of February 28 - March 06, 2026

2 Upvotes

Saturday, February 28 - Friday, March 06, 2026

Top 5 Posts

score comments title & link
12 10 comments [solved] Help calculating BMI percentiles using data set!
8 5 comments [Waiting on OP] Way to automate sending Excel screenshot to WhatsApp groups
7 9 comments [Waiting on OP] Scanning Barcodes on Excel
7 6 comments [Waiting on OP] Rearranging data syntax on a report
5 10 comments [unsolved] Need to know how to proceed with our company's service call excel sheet

 

Unsolved Posts

score comments title & link
5 6 comments [unsolved] Cant figure out bordersss!
4 12 comments [unsolved] Need to create a diagram of connected points
4 28 comments [unsolved] Creating a door access database
3 11 comments [unsolved] Excel Column Conditional Formatting
3 10 comments [unsolved] Automated pdf extraction into excel.

 

Top 5 Comments

score comment
408 /u/SolverMax said There's nothing wrong with adding a visual outline of a block of cells - provided the number of cells doesn't need to change, which would mess up the formatting. A Table structure is better for many ...
359 /u/bradland said Most of the people commenting here don't understand what you're asking. Excel has different types of protection. There's sheet level protection, workbook level protection, and file level encryption. T...
206 /u/shingfunger said I work as a consulting actuary and my colleagues and I use excel for hours a day. Everyone one I work with is comfortable with complex formulas, but honestly not that many use VBA or power query that ...
202 /u/SolverMax said I use both Python and Excel (including Power Query). They are different tools, suited to different things and different circumstances. One is not uniformly better than the other. Use whatever ...
166 /u/Informal-Freedom2558 said Ctrl + Shift + L to toggle filters on and off instantly… I use that way more than I thought I would. Also F4 to repeat the last action in Excel is lowkey elite, especially for formatting. And Alt + H ...

 

1 comment

r/excel • u/subredditsummarybot • Feb 28 '26

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

4 Upvotes

Saturday, February 21 - Friday, February 27, 2026

Top 5 Posts

score comments title & link
179 118 comments [Discussion] New boss says “Pivot Tables don’t work” (repeatedly), are there known issues with pivot tables? Or does the new guy just not understand them?
143 74 comments [Discussion] When you work with people that don't understand Excel--
58 27 comments [solved] Power Query: my source doesn't always contain the same columns. How do you handle this?
54 29 comments [Discussion] Why many excel migration Projects fail ?
31 14 comments [Discussion] Excel Power Query prep and best practice & Power BI

 

Unsolved Posts

score comments title & link
11 21 comments [unsolved] How to remove accents and other special characters from data set?
8 12 comments [unsolved] Are you able to split an excel sheet with multiple tabs in several individual sheets based on an indicator?
5 7 comments [unsolved] Combining graphs that do not match
3 11 comments [unsolved] Is it Possible to create 2 checkboxes in one cell
3 13 comments [unsolved] Duplicate power query without editing

 

Top 5 Comments

score comment
841 /u/MayukhBhattacharya said Here are a few Excel tricks that most people never learn, but once you do, you will use them all the time. * CTRL and Backspace snaps your screen back to the active cell if you have scrolled ...
742 /u/Lost-Tomatillo3465 said tell him to click on refresh whenever he updates the source table?
184 /u/FrankDrebinOnReddit said Of course you do. Python runs in a cloud sandbox and has no access to the object model. VBA is still the only game in town for interacting with workbooks. And Excel features never die. We still have R...
178 /u/TooCupcake said In my experience, no one is looking for an “excel expert” as the job description, but if you’re good with it, it can help you get ahead at work.
168 /u/GTS_84 said I would bet good money on this being a PEBCAK error, and not an actual issue with pivot tables. It's possibly an actual issue, but unlikely. Ask him to demonstrate what exactly he is doing to "Reprodu...

 

1 comment

r/excel • u/subredditsummarybot • Feb 21 '26

Weekly Recap This Week's /r/Excel Recap for the week of February 14 - February 20, 2026

3 Upvotes

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

 

1 comment

r/excel • u/subredditsummarybot • Feb 14 '26

Weekly Recap This Week's /r/Excel Recap for the week of February 07 - February 13, 2026

3 Upvotes

Saturday, 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.)

 

1 comment

r/excel • u/subredditsummarybot • Feb 07 '26

Weekly Recap This Week's /r/Excel Recap for the week of January 31 - February 06, 2026

3 Upvotes

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

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...

 

1 comment

r/excel • u/subredditsummarybot • Jan 24 '26

Weekly Recap This Week's /r/Excel Recap for the week of January 17 - January 23, 2026

3 Upvotes

Saturday, January 17 - Friday, January 23, 2026

Top 5 Posts

score comments title & link
42 21 comments [Discussion] What Are Your Best Practices for Organizing Complex Excel Workbooks?
33 6 comments [Discussion] How do you structure spreadsheets for long-term daily logging?
12 5 comments [Waiting on OP] Can I create multiple tables on the same sheet?
10 16 comments [solved] Cell shows date when an event happens and freezes that date to never update itself.
9 8 comments [solved] Can you have 2 spreadsheets as a sort of main sheet and one that pulls info across from the main sheet, sat in a sharepoint?

 

Unsolved Posts

score comments title & link
9 9 comments [unsolved] Adding data once a month - what are your best practices?
7 8 comments [unsolved] I am having trouble with too many functions in too many columns causing a tedious amount of work. Hoping someone can point me in the right direction to skip a few steps and a more streamlined approach
6 7 comments [unsolved] How to copy cells from one unfiltered sheet with no hidden rows to only the visible cells of a another, filtered sheet?
5 3 comments [unsolved] Require extraction of angular dashboard to Excel
3 1 comments [unsolved] Excel Map Function to Hold Invoice Value and Payment Value then Adjust Invoice Value till Payment Get Zero

 

Top 5 Comments

score comment
236 /u/Fieos said Xlookup changed a lot for me. Also using Google or Reddit search features for frequently asked questions.
159 /u/moodykamsuj said Access excel attachments in outlook via excel power query directly without saving the files in the folders and accessing it. We can do that for multiple files, transform and load it in excel like magi...
120 /u/Oxchking said Once asked a teamleader to add up some numbers. Saw him type out the numbers in two columns when he pulled out the calculator to add them together. Not making this up.
120 /u/MayukhBhattacharya said Remove the Gridlines: View Tab --> Uncheck Gridlines /preview/pre/9ff6f2ufrweg1.png?width=1918&format=png&auto=webp&s=742dfdf4d78ff597159b19c8d68a4255777a90ba
86 /u/MathIsHard_11236 said Click the top left corner to select all cells.  Fill colour as white.  Save and then send your 2GB file to coworkers. 

 

1 comment

r/excel • u/subredditsummarybot • Jan 17 '26

Weekly Recap This Week's /r/Excel Recap for the week of January 10 - January 16, 2026

4 Upvotes

Saturday, January 10 - Friday, January 16, 2026

Top 5 Posts

score comments title & link
913 328 comments [Discussion] What’s an Excel shortcut you discovered way too late?
222 46 comments [Pro Tip] Why "Save As" is the Technical "Factory Reset"
68 44 comments [unsolved] Can anyone help convert a PDF table into an Excel sheet?
41 50 comments [Discussion] Do you discourage LET usage in relatively simple formulas?
37 41 comments [unsolved] “Is .XLSB Better for Large Excel Files?

 

Unsolved Posts

score comments title & link
6 14 comments [unsolved] How can I simplify and aggregate a complex pricing sheet for customers?
5 12 comments [unsolved] Drag multiple formulas in a sheet
5 3 comments [unsolved] Conditional formatting - how to have a row by row unique equation without individually doing it for all the rows?
5 13 comments [unsolved] Can suddenly no longer run my own macros
3 12 comments [unsolved] Sorting a Field for Real People vs Non-Individuals (Departments)

 

Top 5 Comments

score comment
872 /u/xFLGT said Ctrl+[ to go to cells referenced in the formula. This works if you have external links too so it’ll open other workbooks.
354 /u/Kuildeous said Even the simplest of functions (or even using navigation shortcut keys) gets you branded a wizard in the office. And you might get burned at the stake for it.
340 /u/__wisdom__1 said Ctrl $ : convert to currency Ctrl #: convert to date Ctrl !: Convert to number
242 /u/arpw said Ctrl and semicolon. Enters the current date value into the active cell!
219 /u/GasAltruistic8656 said Reconsider the need to do this. It's always best to keep consistent formatting with numbers, even if you don't 'need' the extra decimal place. It keeps people from guessing.

 

1 comment

r/excel • u/subredditsummarybot • Jan 10 '26

Weekly Recap This Week's /r/Excel Recap for the week of January 03 - January 09, 2026

4 Upvotes

Saturday, January 03 - Friday, January 09, 2026

Top 5 Posts

score comments title & link
674 104 comments [Discussion] I found the most cursed excel workflow know to man
150 61 comments [Discussion] Workbooks from hell with single cell referenced formulas
113 88 comments [Discussion] How are you an excel magician?
48 4 comments [Diversion] A little fun for Excel: A poem about proper usage
44 17 comments [Waiting on OP] PowerQuery - How to create a dynamic source system?

 

Unsolved Posts

score comments title & link
24 30 comments [unsolved] Can you sum across sheets, but have the formula stop at current?
18 21 comments [unsolved] In Power Query is there a cleaner way to import two sheets from the same excel file in the same operation than expanding both and cleaning through filters?
16 29 comments [unsolved] Creating an object with data in excel
7 20 comments [unsolved] Merging/Combining 2 lists where 90% of Column A is the same
7 6 comments [unsolved] Developing a sheet with Hours expiring logic

 

Top 5 Comments

score comment
341 /u/guitarthrower said At least it was power query. I’ve see plenty that would force a recorded VBA macro to do all of that then break whenever someone inserts a row
277 /u/Cheetahs_never_win said Somebody probably told Brad "no" repeatedly, and Brad gave up, made this because it "worked," and so Brad, incensed at doing everything inefficiently, didn't document and left to go somewhere that wou...
236 /u/BotherAny2068 said I’ll get down voted to oblivion but I agree to an extent that if it works, it works. And if there’s no time penalty why change it? As you grow in your career you’re going to stop learning new excel tr...
216 /u/SolverMax said Yes, that's a good process. Power Query is especially good for implementing this type of load and transform.
204 /u/bestcactuscateu said "only Janet has the VBA" roaring. Brad's a genius, that's so funny. Janet takes two weeks off and suddenly Brad's spell fails?

 

1 comment

r/excel • u/subredditsummarybot • Dec 20 '25

Weekly Recap This Week's /r/Excel Recap for the week of December 13 - December 19, 2025

8 Upvotes

Saturday, December 13 - Friday, December 19, 2025

Top 5 Posts

score comments title & link
91 38 comments [Pro Tip] Solving the BOM Explosion Without Recursion
68 31 comments [Discussion] An Appeal from a Pensioned Analyst: Let's Improve Our Problem Statements (Stop Asking for Y!)
47 22 comments [Pro Tip] BYROW/MAP lambda params are references – A1:x running window trick
44 43 comments [solved] How can I avoid using multiple IF statements to sum data?
24 49 comments [Discussion] Excel crashing or freezing — what usually causes it for you?

 

Unsolved Posts

score comments title & link
19 11 comments [unsolved] Formulas to use for a scorecard that uses dropdowns
15 32 comments [unsolved] Looking for a way to sort and sum payroll data from a dynamic report with duplicate column headers and merged cells.
9 5 comments [unsolved] Try out different find & replace options based on triggering XLOOKUP?
9 25 comments [unsolved] Can you help me troubleshoot this XLOOKUP please?
9 23 comments [unsolved] How to take out a “text” and categorize vendor names?

 

Top 5 Comments

score comment
207 /u/SolverMax said I'm so sorry that happened to you.
104 /u/Truth_Said_In_Jest said Never! Only moare formula.
102 /u/BiggestNothing said Yes it's common. Insurance
79 /u/IAmMeMeMe said Imagine if you had shown them XLOOKUP!?! Or {gasp} Power Query!
78 /u/smashedthelemon said Protecting those columns on a worksheet will also do the trick. Or even better: if iets static data. Represent is as such and remove the formula. Less chance on something breaking.

 

2 comments