Hi All,
I am trying to work on a tracker sheet which involves getting the list of assignments listed down based on their completion date. The attachment has details and format. The base sheet is the data which I have exported from MS Project and I want to convert this data into the Top sheet.
I have tried VLOOKUP function to get the details of the assignments done in one month but it is not giving multiple outputs.Moreover I would like this output in a single Cell if possible.
I am also not able to compare the dates from both the sheets as the date format is different. I am converting all the end date to one particular date and then comparing.
Kindly advise on how to proceed in this..
Regards,
Murthi
Bookmarks