Help with multiple conditions using MS Excel 2010

[krllb]

Hi Excel Guru's,

I need your help. I am creating a report where there are multiple conditions and I am using MS Excel 2010.

Summary sheet will display
Date of Completion - If the exam has been taken already
In Progress - if the exam has been started but not yet completed
Not Started - if the exam has not yet been taken

Available data in Source sheet
Completion_Date - Date when the exam was taken or "Blank" if the exam is still In Progress
Completion_Status - Completed & In Progress only (all subjects that are not in the Source sheet shall be tagged as "Not Started"

Hope you can help me out. Thanks!

[azumi]

Something like this? perhaps, pls see the file attach, Im using array formula with has "{}" sign in there, do not just ENTER alone, you need topress CTRL-SHIFT-ENTER button together

[ashishmehra2010]

Hi Azumi,

Could you please look at Column G where required results are not coming right.

Regards,
Ashish

[azumi]

Hi Azumi,

Could you please look at Column G where required results are not coming right.

Regards,
Ashish

Hi, you right, wrong logic, already updated the file, Thanks for checking...

Regards

[krllb]

It worked! Thanks a lot azumi and ashishmehra2010.