Calculate if column is more than next column then increment row

Copper 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))