Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Each month we need the identities of employees who joined the company 3
months and one year ago. It is nonsense to go through the list manually, but I can't find a way to do it automatically. Ideally, I would end up with a separate spreadsheet, or even a separate section of the existing spreadsheet, that contains the names and other data from persons who match the criteria: Name, Hire Date, Job Title, Department, month FOR Records WHERE (Month of Hire Date) = (This Month - 3 months) OR (Month of Hire Date) = (This Month -12 months). And collects them all in a nice, tidy box I can ship to the relevant managers. Sorted by Department. Lightly scented with lavender. Seems simple, but is beyond me. I'm a real newby at this, so if you use abbreviations, I am guaranteed not to understand them. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Randomly select records | Excel Discussion (Misc queries) | |||
Select records to new workbook | Excel Discussion (Misc queries) | |||
Top 5 records by month | Excel Discussion (Misc queries) | |||
Randomly Select Records | Excel Worksheet Functions | |||
select records with a specific value | Excel Worksheet Functions |