LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8
Default Select records by month

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Randomly select records Tammy Excel Discussion (Misc queries) 12 September 20th 07 07:42 PM
Select records to new workbook wal50 Excel Discussion (Misc queries) 2 September 20th 07 01:26 PM
Top 5 records by month tmirelle Excel Discussion (Misc queries) 3 March 14th 07 10:39 PM
Randomly Select Records Critzy Excel Worksheet Functions 6 March 12th 07 10:41 PM
select records with a specific value AMK Excel Worksheet Functions 3 June 22nd 05 11:53 AM


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"