ExcelBanter - populate backwards

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - populate backwards (https://www.excelbanter.com/excel-worksheet-functions/122354-populate-backwards.html)

Lp12

populate backwards

Hi All,
I have two columns one: A1 value 100,A2 value 201,A3 value 33. I need to put
in B1 the value of A3, B2- A2,B3-A1. Is there a way to acomplish that with
the help of a formula?
Thanks a lot in advance,
Assaf

RichardSchollar

populate backwards

Hi Assaf

Try:

=INDEX($A$1:$A$3,ROWS($B1:$B$3))

copied down.

Hope this helps!

Richard

Lp12 wrote:

Hi All,
I have two columns one: A1 value 100,A2 value 201,A3 value 33. I need to put
in B1 the value of A3, B2- A2,B3-A1. Is there a way to acomplish that with
the help of a formula?
Thanks a lot in advance,
Assaf

All times are GMT +1. The time now is 07:17 AM.