• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to extract data from two different worksbooks based on a condition?

A

abi

New Member
I have two worksheets having some common fields.

Common fields in Sheet1 in workbook1 and sheet1 in workbook2 are start date,end date, issue number, status(either closed or open) and priority.

What i wanted is,
Sheet1 in workbook3 must have the result as count of the issues that were open on each monday and their priority.

Could someone help me with this not using VBA?
 

Attachments

  • workbook1.xls
    13.5 KB · Views: 7
  • workbook2.xls
    13.5 KB · Views: 6
You mean to say the start date shld be a Monday, or any Monday b/w the start date & end date.

To determine if the start date is Monday use =CHOOSE(WEEKDAY(A2),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
In Sheet1 in workbook3 use If formula to determine the count & priority
 
Hi, abi!
I forgot about this topic. I've read it a few days ago and didn't understand what to do exactly. Would you please elaborate a bit more and post the manual output desired in workbook3? Take care of include in 1 & 2 all the cases required for testing. Thank you.
Regards!
 
You must log in or register to reply here.
Back
Top