•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