How to identify staff who has deptcode change

[lee-sc]

Hello,

I need urgent help for the following case. To setup a formula after
deptcode, base on staff No. to identify who have how many time transfer
deptcode from one to another. Please note sometime the reason codes are same
but dept codes are changes (like row 3 & 4 )

Staff No. Action/Reason Deptcode
R1 0001 Pay chg 1234
R2 0001 Pay chg 1234
R3 0001 Data Chg 1234
R4 0001 Data chg 1239
R5 0005 Incentive chg 3456
R6 0005 Data Chg 9888
R7 0005 Data Chg 7865
R8 0009 Data Chg 7865
R8 0009 Data Chg 9990

Thanks.

 

[Max]

This looks similar to your earlier posting y'day (you posted using the name:
"Calculate Date range"), for which I ventured a response? You should feedback
and engage the responder(s) there instead of starting a new thread. I may not
have anything further to offer you if the earlier response didn't work out ok
for you, but others might.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[lee-sc]

Hi Smartin,

The formula is workable for me. Thanks much.

for curioursity, the 1st formula, 1+D1 is for what purpose ?