Comparing Differences Between Entries based on Two Other Columns

[cgfrank]

So I've got a complicated spreadsheet.
Column A is a name.
Column E is a field saying "first" "second" "third", etc, based on the number of interactions we do with that person.
Column K is a numerical points value.

Some people from Column A have multiple interactions with us, and each one is labelled first, second, third, etc, and each one will end up with a separate point value in column K, based on their score on the inspection we do.

Now, I'd like to add a column or two in that show the difference between the 1st/2nd/3rd point values based on the name in Column A.

IE
Column A has Joey getting 3 inspections. Column E says 1st, 2nd 3rd. Column K has point values that say 1, 18, 32.

I'd like a column that would be labelled 1-2 (difference between first and second inspections) and the entry be calculated as the difference between the two, so +17. And then a 2-3 column would show a value of +14.

Am I nuts? Is this possible?

 

[Snakehips]

Flattery will get you everywhere....

Formula in P4..... =IF(COUNTIF($B$4:$B$10000,B4)=0,"",COUNTIF($B$4:$B$10000,B4))

and drag down as required.