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

Hi Angelaf,

For employee ID 003, it could be as simple as:
=C3-C21
This will return 'True' if the increment is greater than 1, 'False' otherwise.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Angelaf" wrote in message ...
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

Try in D2:
=IF(COUNTIF(A$2:A2,A2)=2,IF(C2-INDEX(C:C,MATCH(A2,A:A,0))1,"x",""),"")
Copy down. Col D will flag it as "x" as specified, ie whe
Emp ID = previous Emp ID and point previous point +1 ?

Note that in your posted data, no line qualifies. Perhaps you meant "=",
not "" ? If so, just change the "1" part in the expression to "=1"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Angelaf" wrote:
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

What do you want the formula to return?
Where is previous point?


"Angelaf" wrote in message
...
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