Deducting each previous columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1714755%22%20slang%3D%22en-US%22%3ESubstract%20prev%C5%9Fous%20monothly%20kumulative%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1714755%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20set%20of%20data%20showing%20cumulative%20totals%20monthly%20in%20December%20column(%20is%20cumulative%20of%20Jan%20to%20November).%20Is%20there%20a%20formula%20to%20subtract%20each%20month%20from%20previous%20month%20figures.%3C%2FP%3E%3CP%3EI'm%20using%20the%20copy%20-right%20click-paste%20special%20and%20subtract%20way%20and%20its%20taking%20ages%20and%20not%20efficient.%20I%20need%20to%20solve%20this%20very%20badly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20in%20advance.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3EAsli%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1714755%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

Hi, 

 

I have a set of data showing cumulative totals monthly. in e.g. in column for December( is cumulative of Jan to November). Is there a formula to subtract each month from previous month figures.

I'm using the copy --paste special -- subtract columns-and its taking ages and not efficient. I need to solve this very badly.

 

Is there any easy way/formula to subtract previous columns?

 

 

0 Replies