• 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.

Retrieve info using formula

Dee

Member
I have list of project from which i have created pivot table to give the exact date each stages of the project. I need to extract the details of the projects between two date range(for ex: from 1st Nov 2009 to 30th Nov 2009)if they have passed any stage in the period.


Thanking you in advance,

Dea
 

xld

Member
Try a form of SUMPRODUCT


=SUMPRODUCT(--(date_range>=start_date),--(date_range<=end_date),--(stage_range=stage))
 

Dee

Member
Hi,Thanks for your quick reply.

I tried this, but not working.

Each stage date is in different column.I need know how many crossed that phase and how many came into that phase wihtin that range.
 

Hui

Excel Ninja
Staff member
Dee, Can you post a sample somewhere?

http://chandoo.org/forums/topic/posting-a-sample-workbook
 

Dee

Member
Hui,


As i am unable to access those sites(at present) i am giving snapshot of the pivot table below.For some date is blank as the project is still in previous phase.Info that i need to retrieve are how many came in,how many went out of each phase,Prj manager's name,project name,ID#.


ID # Prj Manager Project Name Phase1 Phase2 Phase3 Phase4

116772 Ole Consumables 29-May-09 29-Nov-09 14-Dec-07 10-Oct-08

117332 Srinivas NCC Program 3-Dec-08 23-Jun-09 24-Apr-10 11-Oct-10

118112 Mujibur Rahman Synergy 28-Apr-10 (blank) (blank) (blank)


Thanks,

Deepa
 

Hui

Excel Ninja
Staff member
Hi Dee


In your list above you have for example ID 116772 Phase 2 29-Nov-09

Is that when Phase 2 started or finished?


and what you want a list of how many started and finished in each phase between certain dates?


Is the above both correct, please clarify if not
 

Dee

Member
Hi hui,


The date represent the completion of that particular phase.

The end date of phase 1 will be the start date of phase 2.

It's exactly the same what i am looking for...


Thank you very much
 
Top