But I am not good enough at functions to write one to do this!
I need to find out the number of unique employee IDs with hire dates between a certain date range. Can anyone help? I want to be able to simply paste a function into a summary spreadsheet that will count how many new hires there were on a particular week.
What I have been doing is to use Auto Filter to show the new hires between the dates I want, and then copying those entries to a new spreadsheet and doing an advanced filter on the employee ID numbers to find the number of unique values.
Can anyone recommend an easier way? Thanks in advance!
employee_id last_name first_name hire_date
071001000000000269 8/14/2006
071001000000000269 8/14/2006
071001000000000269 8/14/2006
071001000000000270 8/14/2006
071001000000000270 8/14/2006
071001000000000270 8/14/2006
071001000000000270 8/14/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000285 8/16/2006
071001000000000288 8/16/2006
071001000000000288 8/16/2006
071001000000000288 8/16/2006
071001000000000288 8/16/2006
071001000000000288 8/16/2006
071001000000000288 8/16/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000290 8/18/2006
071001000000000290 8/18/2006
I need to find out the number of unique employee IDs with hire dates between a certain date range. Can anyone help? I want to be able to simply paste a function into a summary spreadsheet that will count how many new hires there were on a particular week.
What I have been doing is to use Auto Filter to show the new hires between the dates I want, and then copying those entries to a new spreadsheet and doing an advanced filter on the employee ID numbers to find the number of unique values.
Can anyone recommend an easier way? Thanks in advance!
employee_id last_name first_name hire_date
071001000000000269 8/14/2006
071001000000000269 8/14/2006
071001000000000269 8/14/2006
071001000000000270 8/14/2006
071001000000000270 8/14/2006
071001000000000270 8/14/2006
071001000000000270 8/14/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000234 8/16/2006
071001000000000285 8/16/2006
071001000000000288 8/16/2006
071001000000000288 8/16/2006
071001000000000288 8/16/2006
071001000000000288 8/16/2006
071001000000000288 8/16/2006
071001000000000288 8/16/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000289 8/18/2006
071001000000000290 8/18/2006
071001000000000290 8/18/2006