between rows

  1. S

    how do i compare rows within each group?

    Hello, How would I calculate the value of colB[row2]-colB[row1] for a group of records/rows in Excel but only within that group of records? In other words, if a value in A changes, don't do the calculation between the first row of the new value and the last value of the previous value in A...

Some videos you may like

This Week's Hot Topics