I'm back needing more help.
On a workbook i have, we record the customers details in columns A - E.
In column J is the name of the staff member looking after that customer.
In column I is the date work was received for that customer.
Each member of staff has about 300 customers each. What I want to do is on sheet 3 (named stats) I want to be able to enter the staff members name, and find the oldest date that they have to their name.
I have tried =MIN(IF((Sheet1!J2:J1300="MICHELLE"),Sheet1!I2:I1300)) but that returns 0-Jan-1900 as not all cases have work outstanding. I have tried formatting cells and that doesnt work.
Can anyone help?
Thanks
Bookmarks