Calculate if column is more than next column then increment row

%3CLINGO-SUB%20id%3D%22lingo-sub-1529531%22%20slang%3D%22en-US%22%3ECalculate%20if%20column%20is%20more%20than%20next%20column%20then%20increment%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529531%22%20slang%3D%22en-US%22%3E%3CP%3EBeen%20trying%20to%20create%20a%20formula%20which%20checks%20if%20the%20column%20is%20less%20than%20the%20next%20column%20and%20then%20increment%20the%20row%2B%2B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1529531%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529656%22%20slang%3D%22en-US%22%3ERe%3A%20Calculate%20if%20column%20is%20more%20than%20next%20column%20then%20increment%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529656%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F732084%22%20target%3D%22_blank%22%3E%40jacksaxby%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHeaders%20in%20row%201%20and%20data%20starts%20in%20row%202.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(A2%26gt%3BA1%2CB1%2CSUM(B1%2C1))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529776%22%20slang%3D%22en-US%22%3ERe%3A%20Calculate%20if%20column%20is%20more%20than%20next%20column%20then%20increment%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529776%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3BPerfect%2C%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Been trying to create a formula which checks if the column is less than the next column and then increment the row++

2 Replies

@jacksaxby 

Headers in row 1 and data starts in row 2.

=IF(A2>A1,B1,SUM(B1,1))