Ask Your Question
0

How to subtract from row above and output to a different column for all rows?

asked 2019-01-28 21:17:06 +0100

Drfox gravatar image

so I want to subtract from row above and output to a different column for all rows. for instance

1

3 2

4 1

8 4

But I want to do this for all rows in the A column. and output into the C Column Any help is appreciated.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-01-28 21:21:48 +0100

updated 2019-01-28 21:24:04 +0100

In B2:

=A2-A1

and drag-copy down.

edit flag offensive delete link more

Comments

Thank you very much this worked well

Drfox gravatar imageDrfox ( 2019-01-28 22:10:12 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-01-28 21:17:06 +0100

Seen: 26 times

Last updated: Jan 28