•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to do pairwise addition on excel?
Embarrassing, but for the life of me, I cannot add two adjacent pairs of numbers without Excel repeating it for some reason. For example, in a new column B, I want to be able to do this:
B1 = A1+A2
B2= A3+A4
B3= A5+A6 and so on...
But for some reason, Excel seems to mess up the pattern when I drag it down. Any suggestions?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#Excel
#pairwise addition
#adjacent pairs
#numbers
#formula
#drag down
#column B
#pattern
#A1+A2
#A3+A4
#A5+A6
#sheets
#data entry
#repeating