J
Jeannie
Hopefully, this is the last time I will be posting requesting a formula for
this spreadsheet I have been working on all week. I have a worksheets which
shows all the employees that were hired and the ones that left the company.
One of my column (H) does a count where it adds 1 for arrivals and substract
1 for departures. I need to be able to know what that number is at the end
of each month.
My columns are the following:
A = Office
B = Employee ID
C = Name
D = Arrivals
E = Status (TRUE for arrivals and FALSE for departures)
F = addition or substraction (1 or -1)
G = Count
So basically, if column E is the last date of the month, I need to have a
formula which will take the number in column H. Here is a portion of the
date, in case it would help create the formula I need.
1185
LON 16106 Doe, Jane 2007-01-01 TRUE 1 1186
MTL 17063 Doe, John 2007-01-02 FALSE -1 1185
OTT 18014 Smith, John 2007-01-02 TRUE 1 1186
MTL 18067 Smith, Jane 2007-01-03 TRUE 1 1187
OTT 18072 Wilson, John 2007-01-03 TRUE 1 1188
MTL 16811 Wilson, Jane 2007-01-05 FAUX -1 1187
MTL 17699 Smith, David 2007-01-31 TRUE 1 1188
I would need 1188 to be the result of the formula
Thanks for your help
Jeannie
this spreadsheet I have been working on all week. I have a worksheets which
shows all the employees that were hired and the ones that left the company.
One of my column (H) does a count where it adds 1 for arrivals and substract
1 for departures. I need to be able to know what that number is at the end
of each month.
My columns are the following:
A = Office
B = Employee ID
C = Name
D = Arrivals
E = Status (TRUE for arrivals and FALSE for departures)
F = addition or substraction (1 or -1)
G = Count
So basically, if column E is the last date of the month, I need to have a
formula which will take the number in column H. Here is a portion of the
date, in case it would help create the formula I need.
1185
LON 16106 Doe, Jane 2007-01-01 TRUE 1 1186
MTL 17063 Doe, John 2007-01-02 FALSE -1 1185
OTT 18014 Smith, John 2007-01-02 TRUE 1 1186
MTL 18067 Smith, Jane 2007-01-03 TRUE 1 1187
OTT 18072 Wilson, John 2007-01-03 TRUE 1 1188
MTL 16811 Wilson, Jane 2007-01-05 FAUX -1 1187
MTL 17699 Smith, David 2007-01-31 TRUE 1 1188
I would need 1188 to be the result of the formula
Thanks for your help
Jeannie