Melinda
04-19-2007, 01:10 PM
I need to write a formula that pulls the earliest start date for each employee, an employee may have several lines, that has "n" as active and put this in a seperate table.For example, Christine Mills was paid $177.08 per pay period from 06/02/06 - 08/16/06. Christine Mills was paid $185.92
per pay period from 08/17/06 - 12/14/06. Christine Mills was paid $191.46 per pay period from 12/15/06 until the end of the fiscal year.(So that makes this record active(Y) and the first two records nonactive(N)).
I would like to be able to pull and list each, on seperate lines, of Christine's earliest nonactive(N) and active date(Y) start date.
View in a table:
N Christine Mills 06/02/06
Y Christine Mills 12/15/06
See attached excel file for example.
I have tried MATCH and LOOKUP but can not get it to work. Can anyone help me with a function that possible will work.
Melinda:help
per pay period from 08/17/06 - 12/14/06. Christine Mills was paid $191.46 per pay period from 12/15/06 until the end of the fiscal year.(So that makes this record active(Y) and the first two records nonactive(N)).
I would like to be able to pull and list each, on seperate lines, of Christine's earliest nonactive(N) and active date(Y) start date.
View in a table:
N Christine Mills 06/02/06
Y Christine Mills 12/15/06
See attached excel file for example.
I have tried MATCH and LOOKUP but can not get it to work. Can anyone help me with a function that possible will work.
Melinda:help