TransWikia.com

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

Super User Asked on December 25, 2021

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.

enter image description here

3 Answers

With Excel 365 you can use SEQUENCE() and SORTBY(). Enter this formula into cell C2:

=A1:A10+SORTBY(B1:B10,SEQUENCE(10,,10,-1))

Answered by bkraines on December 25, 2021

You can also use INDIRECT.

= A1+INDIRECT("B" & 11-ROW())

Answered by Moshe Lilintal on December 25, 2021

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

Answered by Koen G. on December 25, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP