- Jul 28, 2004
Suddenly this has turned into me, no joy.Nope no joy but thank you
I'll try one more time to understand.
You started the thread with the above, but now in your last post, you are showing a date for every employee, not just the Min.How can i find the minimum date? from the employee sheet?
Susan would =12/11/2015
Susan would =15/11/2015
Terry would =13/11/2015
Terry would =18/11/2015
Gary would = 14/11/2015
Gary would =16/11/2015
Since the names above are listed twice, why are your expecting two dates for the duplicate name?
You threw Max into the thread at one point, but I'm really befuddled as too what we are trying to accomplish here outside of the MIN(IF construct you have been given.
I'm losing energy on continuing in this thread as you did not even answer any of my last questions.
How is what you last posted for the Employee sheet any different from the results you cite for the Attendance sheet?
All names and dates are listed in both places...