Excel: how do I add one column from start to end with another one from end to start in excel?

Question

Suppose I have two columns A and B, each have 10 elements, I want to get a column A1+B10, A2+B9, etc.
When I fill =A1+B10 and do the 'double click' to auto fill the rest, it cannot give me the right answer.
To be clear, I don't want modify column A or column B, and I don't want to sort A and B either, just keep them intact and get column C by just fill one cell and double click to auto fill the rest.

bkraines · Answer

With Excel 365 you can use SEQUENCE() and SORTBY(). Enter this formula into cell C2:
=A1:A10+SORTBY(B1:B10,SEQUENCE(10,,10,-1))

Moshe Lilintal · Answer

You can also use INDIRECT.
= A1+INDIRECT("B" & 11-ROW())

Koen G. · Answer

You can use INDEX and ROW with some calculations:
= A1 + INDEX(B$1:B$10;10-ROW(C1)+1)

Excel: how do I add one column from start to end with another one from end to start in excel?

3 Answers

Add your own answers!

Ask a Question