D
dickharlo
I have the following table in Excel, pulled in from MS Access:
Buckley Employee 7 active
Buckley OffShore 1 active
Buckley OffShore 1 deactivated 08/30/07
Buckley OnShore 1 deactivated 01/19/07
Buckley T&M 1 deactivated 02/16/07
Buckley T&M 3 deactivated 08/15/07
What I need to do....is compare the date here to another date. If the
date on this table is greater than the date i'm comparing to....then I
want to capture the count for all. Example would be concatinate =
'BuckleyOffshore' in which case I would capture 1+1+1 and result
should be 3, if my compare to date is 1/1/2007.
If the date I am comparing to is 2/10/07 as example....then I want to
exclude any rows on this table with Less Than 2/10/07.....so I want to
return only 1+1 for result of 2, where concatination =
'BuckleyOffshore'.
The compare to date I'm using is based on each week of the year. So
in one row I'll have 1/1/07, then next row 1/7/07, then 1/14/07 and so
on. At each row I need to do this compare...and capture total results
where Table Date is > compared to date.
Buckley Employee 7 active
Buckley OffShore 1 active
Buckley OffShore 1 deactivated 08/30/07
Buckley OnShore 1 deactivated 01/19/07
Buckley T&M 1 deactivated 02/16/07
Buckley T&M 3 deactivated 08/15/07
What I need to do....is compare the date here to another date. If the
date on this table is greater than the date i'm comparing to....then I
want to capture the count for all. Example would be concatinate =
'BuckleyOffshore' in which case I would capture 1+1+1 and result
should be 3, if my compare to date is 1/1/2007.
If the date I am comparing to is 2/10/07 as example....then I want to
exclude any rows on this table with Less Than 2/10/07.....so I want to
return only 1+1 for result of 2, where concatination =
'BuckleyOffshore'.
The compare to date I'm using is based on each week of the year. So
in one row I'll have 1/1/07, then next row 1/7/07, then 1/14/07 and so
on. At each row I need to do this compare...and capture total results
where Table Date is > compared to date.