Conditionally Populate one column from another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

Need help with solution for following scenario

I want to build a list of names by selecting only those employees that worked anytime during a designated period

Sheet 1 (Row layout)
Col A: Contains last name of employe
Col B: Contains start date for employe
Col C: Contains termination date for employee (what value should this be if employee still employed wit
company - ???)
Col F row 1: Contains begin date of designated period
Col F row 2: Contains end date of designated period

Sheet2 (contains result)
Sheet2 Column A want to populate this column with ONLY the last names of employees that were working during th
the begin and end dates of the designated period. (Note: changing begin and end dates should "dynamically
result in new Sheet2 Column A list of names

Much appreciate your assistance
Woody
 
Woody,

You can use an advanced filter, but you need to change the location of your
criteria cells.

Copy Column B's header (something like "Start Date") copy that into cell F1.
In cell F2, enter your "begin date of designated period" with <= before it.
Also enter this value in F3.

Copy Column C's header (something like "Term Date") copy that into cell G1.
In cell G2, enter your "end date of designated period" with >= before it. In
G3, copy and paste this
="="

(That's to account for active employees whose termination date isn't filled
in.

Then select your data table (A1 to C???) and use Data | Filter | Advanced
Filter.... and choose F1:G3 for the criteria range, and press OK. If you
want to copy the list elsewhere, select column A and use Edit | Go To...
Special.... "Visible cells only" and then do your copy.

HTH,
Bernie
MS Excel MVP

woody said:
Hello,

Need help with solution for following scenario:

I want to build a list of names by selecting only those employees that
Click to expand...
worked anytime during a designated period.
Sheet 1 (Row layout):
Col A: Contains last name of employee
Col B: Contains start date for employee
Col C: Contains termination date for employee (what value should this be
Click to expand...
if employee still employed with
company - ???)
Col F row 1: Contains begin date of designated period.
Col F row 2: Contains end date of designated period.

Sheet2 (contains result):
Sheet2 Column A want to populate this column with ONLY the last names of
Click to expand...
employees that were working during the
the begin and end dates of the designated period. (Note: changing begin
Click to expand...
and end dates should "dynamically"
 
Back
Top