•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 18 - April 24, 2026
Our take
Welcome to this week’s recap of the /r/Excel community for April 18-24, 2026. Dive into the top discussions, where users tackled challenges ranging from combining AND and OR conditions in formulas to unresolved issues with Power Query and Excel's buffering. Explore insights from the most engaging comments, including tips on handling binary conversion quirks and formula troubleshooting. This week's highlights reflect a vibrant exchange of knowledge and support, empowering users to enhance their Excel skills and streamline their workflows. Join the conversation!
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
[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 25 - May 01, 2026Saturday, 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 ... 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]
- Stop using ungodly INDEX math to flatten 2D schedules. TOCOL() + FILTER() is all you need.This comes up constantly. Someone gets handed a resource tracker or a system export where tasks are split across "Morning Task" and "Afternoon Task" columns, and they need a flat list to dump into a Pivot Table. Simple enough ask. The fun part? Half these exports don't even leave cells blank - they write out [empty] as literal text, so any trick that relies on detecting blank cells just falls flat. And on top of that there's usually a Status column you need to drag along, but only once per person - not stamped next to every single task row like a broken rubber stamp. Old solution was some deeply cursed nested INDEX/ROW formula that nobody could read six months later. If you're still doing that, please stop. On Office 365 you can handle the whole thing in one shot: =LET(data, A2:C11, status, D2:D11, col_data, TOCOL(data), col_status, TOCOL(IF(SEQUENCE(1,COLUMNS(data))=1, status, "")), FILTER(HSTACK(col_data, col_status), col_data<>"[empty]")) TOCOL flattens the grid, the IF/SEQUENCE combo makes sure the status only shows up next to the name and not repeated under every task, HSTACK glues the two columns together, and FILTER kills all the [empty] noise. Keep your ranges the same size throughout or you'll get a #VALUE! staring back at you. These dynamic array functions honestly flew under the radar for a lot of people who don't spend their weekends reading Excel update logs. Hope it saves someone a headache. Note; for Excel 2019 and 2021 you can use power query. However in the 2021 version you can use the filter and sequence function. In 2021 version; the formulas are; =FILTER(INDEX(A2:C11,MOD(SEQUENCE(30)-1,10)+1,INT((SEQUENCE(30)-1)/10)+1),INDEX(A2:C11,MOD(SEQUENCE(30)-1,10)+1,INT((SEQUENCE(30)-1)/10)+1)<>"[empty]") and =FILTER(IF(INT((SEQUENCE(30)-1)/10)+1=1,INDEX(D2:D11,MOD(SEQUENCE(30)-1,10)+1),""),INDEX(A2:C11,MOD(SEQUENCE(30)-1,10)+1,INT((SEQUENCE(30)-1)/10)+1)<>"[empty]") one thank go at user for pointing it out to me Excel_User_1977 submitted by /u/Good-Willingness2234 [link] [comments]
- Issue with Excel Power QueryIn my excel workbook I have a long string of queries to get the results I want, however I am noticing a small number of duplicates that SHOULDNT be able to exist. In my first query in this string, I am adding a new column (SelectionBucket), based on two other columns - Works. Then taking this SelectionBucket column, and adding another column (IsRequiredBucket) based on [SelectionBucket] returning one of the required values - Works. I then am adding an index at this time (CourseIndex) - Works. Result: Courses have Index, and SelectionBucket and IsRequiredBucket as options. Q2 (Reference to Q1): Adding Column (IsRequiredCandidate) where [IsRequiredBucket] = True - Works. Filters out to ONLY true values next, and sorted on (Name) (Ascending), (SelectionBucket) (Ascending), (EMark) (Decending) - Works. Result: Filtering down to only RequiredBuckets, sorted by Best to Worst. Q3 (Reference Q2): I group the rows based on (Name) and (SelectionBucket), call it [AllRows]. Add Column (TopRequired) with Table.FirstN(Table.Sort([AllRows], {{"EMark",Order.Descending}}),1) to return the BEST value - Works. Expand the [TopRequired] Table, excluding Name and SelectionBucket - Works. Add column (SelectionType) = "Required" This is where I am not sure if it is working or not, because for 99% of my data, this works. But for some of the entries, this isn't working. Add one more column (IsRequiredSelected) to check (SelectionType), if "Required" = TRUE. Result should be: Selection of one result for each of the buckets available per entry, and setting its (IsRequiredSelected) value to TRUE. Q4 (Reference Q1): I merge Q4(which is just Q1), to Q3, matching on (CourseIndex), Expand the merge (SelectionType). Rename (SelectionType) to (RequiredTag). Add column (IsRequiredSelected) checking [RequiredTag] to return TRUE for "Required", FALSE otherwise. Q5 (Reference Q4): Add Column (IsAdditionalCandidate) checking [IsRequiredSelected] = FALSE. Filter (IsAdditionalCandidate) for only TRUE values. Sort by (Name) (Ascending), (EMark) (Descending). Result: Check if (IsRequiredSelected) = TRUE and clearing them out. Q6 (Reference Q5): Group by Name -> [AllRows] with operation of All Rows. Add column (TopAdditional) coded =Table.FirstN(Table.Sort([AllRows], {{"EMark",Order.Descending}}),7). Expand the table [TopAdditional] excluding (Name). Add column (SelectionType) = "Additional" Result: Taking only records that are marked as "Additional" and taking the best 7 results for each (Name). Q7 is an appended query of combining Q3 and Q6, where it should take the Q3 Results, and adds the Q6 results to it, which should result in NO duplicates. Issue: I am receiving some of my entries as a duplicate through a query check, where I see the one record as both an Additional and as a Required. I am not sure WHY or where it is broken, other than where I think it is... I realize I could have done this in less Queries, however I wanted to verify along each step of the way if something went wrong, so that I could fix it as a portion, instead of having to delete and re-write everything. Please note that I CANNOT share the excel file data itself, as it contains confidential information within it. If I haven't explained a step clearly enough, please let me know and I will try to add further information on it. submitted by /u/DLCamilla [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#no-code spreadsheet solutions#generative AI for data analysis#real-time data collaboration#financial modeling with spreadsheets#natural language processing for spreadsheets#AI formula generation techniques#big data management in spreadsheets#conversational data analysis#intelligent data visualization#real-time collaboration#data visualization tools#formula generator#enterprise data management#big data performance#data analysis tools#data cleaning solutions#rows.com