Excel formula for check Last updated value and subtract on next row values

[elsenthil]

HI Guys,

I need a excel formula. Here is my condition.


1) Row A is name and Row B is value.
2) First it has to check what name is updating in last cell on the row A. Then it has to check if the same name is updated on previous cell on the same row on A.
3) Then it has to check what value is updated for that name on the row B.
4) Then it want to subtract the last updated value to previous updated value and the result should display on the row C

For Example:

A B C
1 Good 45
2 Very good 25
3 Bad 56
4 Very good 50 25
5 Good 79 34


Note: The name is not updated by order. Any name can be updated on the row A.
I need excel formula or VBA code for this calculation.

Any one please help me this calculation.

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=585932

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).