•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to compare two full columns without #SPILL error in new Excel?
I need to compare two columns (A:A and B:B) row-by-row to identify matches and differences.
In older Excel versions, I used =A:A=B:B which worked perfectly - it compared entire columns and auto-adjusted when I inserted/moved rows.
In newer Excel (with dynamic arrays), this formula returns #SPILL! error.
I know there's a solution (I used one successfully in mid-2025 but lost the formula. I've asked two diff AI Models but they cant solve it. I'm looking for something SIMPLE not conditional formatting or VBA or long ass formulas that I dont have any idea what's happening.
Can anyone help?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#AI formula generation techniques
#row zero
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#Excel
#columns
#comparison
#formula
##SPILL
#matches
#differences
#dynamic arrays
#simple solution
#conditional formatting
#VBA
#row-by-row