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

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]

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