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

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]

Read on the original site

Open the publisher's page for the full experience

View original article

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