Hi Folks,
I have created a program by which a user can enter any given time period (usually 12 months), and generate the top 5 people for that time period. I need to, if possible, automate a process that suggests one or several different 2 week time period(s) that is are shared with all the top 5 people from the time period. That is to say, if the query is ran for the year 2000 and the top 5 people are:
Al
Jim
Bob
Sally
Jen
I need the computer to suggest a 2-week period (such as February 4, 2000 thru February 11, 2000) in which the 5 people above appear in.
Is this possible?
Any help would be greatly appreciated.
Thank you,
Joe
I have created a program by which a user can enter any given time period (usually 12 months), and generate the top 5 people for that time period. I need to, if possible, automate a process that suggests one or several different 2 week time period(s) that is are shared with all the top 5 people from the time period. That is to say, if the query is ran for the year 2000 and the top 5 people are:
Al
Jim
Bob
Sally
Jen
I need the computer to suggest a 2-week period (such as February 4, 2000 thru February 11, 2000) in which the 5 people above appear in.
Is this possible?
Any help would be greatly appreciated.
Thank you,
Joe