Hi there,
Browser of the forums for a while, first time poster.
I've hit a roadblock and my head is completely puzzled, I don't know how to word my request and I've searched everything to no avail.
I have a data set of ~2000, with columns set out per the example spreadsheet.
What I need is for the names in column B to be grouped, and then if there is any change in the salary from column C, the total difference between the salary from the top row to the bottom row.
For example, Kelly Jones has three entries, the salary in C6 = 50000 , the salary in C8 (which is the final iteration of her name in column B) is 51000 therefore the difference is 1000.
There aren't the same amount of records for every employee. The LIVE data I am using has dates in, too, if that helps. but I've left this out as the dates are within a set range.
I can think of no way to get this difference, I have tried to use the subtotal but can't see a difference option, var wasn't especially helpful either.
Bearing in mind there is ~2000 lines to trying to do this manually would take ages.
Thanks for all your help,
Josh
P.s. The data I am using is mock data with made up names and amounts.
Browser of the forums for a while, first time poster.
I've hit a roadblock and my head is completely puzzled, I don't know how to word my request and I've searched everything to no avail.
I have a data set of ~2000, with columns set out per the example spreadsheet.
What I need is for the names in column B to be grouped, and then if there is any change in the salary from column C, the total difference between the salary from the top row to the bottom row.
For example, Kelly Jones has three entries, the salary in C6 = 50000 , the salary in C8 (which is the final iteration of her name in column B) is 51000 therefore the difference is 1000.
There aren't the same amount of records for every employee. The LIVE data I am using has dates in, too, if that helps. but I've left this out as the dates are within a set range.
I can think of no way to get this difference, I have tried to use the subtotal but can't see a difference option, var wasn't especially helpful either.
Bearing in mind there is ~2000 lines to trying to do this manually would take ages.
Thanks for all your help,
Josh
P.s. The data I am using is mock data with made up names and amounts.