I want to identify all emp id's that have had an increment of more than one
point - something like:

Emp ID= previous Emp ID and point previous point +1 ? Would this be a
nested if statement of some sort?


Emp ID Scale Point
00003 GD10 44
00003 GD10 44
00007 GD10 43
00007 GD10 44
00010 GD10 43
00010 GD10 44