Search results for query: *

Hi Thanks for all your help - I was being stupid and had the formula in the wrong spreadsheet. All working as should now! Again Thanks N

Hi Sorry it's a hidden column - Column C. N

Hi I'm sorry that my explanation wasn't very good - I'll try again. The raw data is used to create a pivot table that takes the Resource Group as the Report Filter. The pivot table then shows the dats by months in the rows and by Status in the columns. This is then used to plot a graph - all...

Hi Skip Below is a sample of the raw data: Resource_Group Resource_Names Start_Date Finish_Date % Complete 01/08/2007 01/09/2007 01/10/2007 01/11/2007 01/12/2007 A NJ 12/12/2007 11/01/2008 0% 0.00 0.00 0.00 0.00 15.00 A JJ 27/08/2007 01/02/2008 60% 5.00 21.00 24.00 22.00 22.00 A NJ 08/01/2008...

Hi Thanks for the quick response - what is being returned is the following: Group Code A 0 A 0 A 0 A 0 A 0 A 1 A 1 A 1 A 1 A 1 etc etc. I then concate them into the Full Group: Full Group A - 0 A - 1 Which is great - but then...

Hi I have tried put the code onto the source sheet but because the department can be repeated over 100 times this isn't returning what I need. Below is a sample of the source data: Group Name Start End A NJ 01.01.07 30.01.07 A NJ 02.02.07 02.02.07 B...

Hi I have a pivot table that produces a pivot chart but depending on which department is selected the number of staff can make the chart unreadable. Is there away of saying have only 6 people per chart based on the selection of from the pivot table page? Thanks for any help with this N

Hi I'm using a pivot table to plot a chart - if I only plot on person the chart works fine, but I will need to plot by numerous people. The chart is a stacked chart so will show for each month stacked data based on A, B and C for each person. But when I add a person to my pivot table - the...

Hi I have spreadsheet that uses the following formula to work out the duration of a task and then spreads it over the months.(thanks for help on previous post) What i now need to do is to take into consideration the % completed and spread this over the remaining months? Any help greatly...

Hi Not sure if you have resolved this - but you need to look at the clean option, which will remove non printable characters and also the find and replace. Find all character returns and replace with a "," Hope this helps Nicola

Hi 1 is the result of the networkday (start date - finish date) - so 1 day out of 21 is 5% I then need to take the 5% and if 50% has been completed it should say 2.5% remaining but I cant seem to get it to produce what i need? Duration % of Month % Complete Remaining 1 4.8% 50.0% 2.4% I...

Hi Again I have the following formula now fully tested and working lovely. The result is then /21 which represents days per month and set as a %. For example if the formula returns 1 day - it will show as 5% in the cell. What I now need to do if take away the % complete from the result...

Hi Thanks - that has worked a treat N

Hi Thanks for the fast response - I have looked at product and that just what i need, i have created: =PRODUCT(D3:E3) How should I combine this with the previous code? N

Hi Skip Sorry for not giving you all the information. Here is the full spreadsheet: Name Status Probabilty Baseline Actual Start_Date Finish_Date NJJ A 100% 1 1 23/08/2007 23/08/2007 NJJ B 75% 5 3.75 17/09/2007 21/09/2007 NJJ B 75% 10 7.5 03/09/2007 14/09/2007 NJJ B 75% 10 7.5 22/10/2007...

Hi Have a look at Outlook 2007 - as this have a business contact manager included, haven't played with myself but think it maybe something to look at N

Hi Thanks for the quick response - that works great for the standard duration. But i have a modified duration that is a calculated field. How could I get the above formula to look at the calculated duration not the actual duration? The calucation is: If Status A then 100% of actual duration...

Hi This is how the the data is currently set out: NJJ 22 days 06/08/2007 08:00 04/09/2007 17:00 NJJ 10 days 06/08/2007 08:00 17/08/2007 17:00 NJJ 1 day 03/09/2007 08:00 03/09/2007 17:00 NJJ 1 day 04/09/2007 08:00 04/09/2007 17:00 NJJ 0 days 04/09/2007 17:00 04/09/2007 17:00 NJJ 15 days...

Hi I have looked at the workday function but this doesn't seem to give me what I would be looking for - unless I'm missing something? I need excel to look produce something along these lines Resource Name - J F M A M J J etc as columns and then split the work remaining using the start and...

Hi I have exported data out from Project and have the following fields: Resource Name, Status, Work Remaining, Start Date, End Date What i need to be able to do is to show the work remaining by month, taking each month to have 21 working days available. So for example if a task start...