How to Count rows based on difference between values in a column ?
Hi,I am trying to create a new column based on column "DieY"I want continuous count based on the difference between each row and the previous one.row 2-row 1, row 3-row 2, row 4-row 3 and so on.if the difference is below a certain value, e.g. 5, set the value to 1.if the difference is above, add 1 to the count.keep the last count until the difference is above the value set in the formula.so eventu...