Search results

Hi, I have a very simplified table with randomised data on: https://skydrive.live.com/redir.aspx?cid=b81cfd1b7bf7bb2c&resid=B81CFD1B7BF7BB2C!213&parid=B81CFD1B7BF7BB2C!195 Is it possible to have excel change the tab colour for the Maternity sheet depending on date and data in Last Working...

Hi Faseeh, Will do, I forgot to save as an xls to look at in work and will be out tonight but will email you over the weekend. Thanks. Wull

Hi Faseeh and thanks for taking the time. That looks closer but there are duplicates on the second table. Take DD as an example, all that the second table is looking for is the lowest number by DD on the first table, so in this case you should see DD beside the 4 on the second column then all...

Hi Faseeh, Sorry for the delay, I had a closer look at that last night. It's not quite doing what I had in mind although at a glance it looks right. The first column on the second table should always run down from 1,2,3... but I noticed that that column on your tables, (D I think it was but...

Hi Faseeh, Thanks for putting the time into that. It loooks exactly like the kind of end result I was going for. I imagined the number column 1,2,3,4... to be entered manually but I see you've managed to have that working automaticaly too :) I will have a look at that over the weekend to see...

Hi Sir and thanks for the response. The intention of the second table is to have the first column running from 1 down to whatever is desired, in this case 4. Both 1 and 2 sit beside a Text1 entry on the first table, the smallest number in the number column beside Text1 being 1 and it is this I...

Hi Faseeh, I wouldn't call it a smarter solution to be honest, more of a cheat. As there is a combo list requiring to pull the project step names from an array, I have set up a validation table with the proj steps. Next step is to read the article on how to create the dynamic validation table...

Hi, Within a table I have 2 columns, one with text and another with numbers. An example being: Text1 1 Text1 2 Text2 1 Text2 2 Text3 3 Text3 4 Is excel able to pull this into another table in another sheet like so: 1 Text1; Text2 2 #NA 3 Text3 4 #NA The idea being that I am...

Sorry Faseeh, late night at work last night and by the time I got home to a win7 build I couldn't face looking at another computer screen. Will try and look at it tonight but to be honest I am worried about the but you mention about not typuing above a row, which is where the title bar is :) I...

Hi Faseeh, I appreciate your input, I know how you feel. I only joined last week and feel I've got a lot of info off the site and forums and wish I could give something back in the way of help rather than just take. In work at the moment so will take that new sheet down when I get home and...

I've just pasted what you have in 'Reworked' column C into my project and it's pulling back titles still but I'm thinking, am I making this more complicated than it needs to be? Just pull up every 3rd row in the offset instead of 1 to allow for the subtotal group header and the manually...

It's almost there although due to lack of experience in Excel I'm not quite fully understanding how you've got that like that. I'll need to investigate a little. Looking at 'Project Step' info in 'Reworked' column C. I noticed that when I try to add a new one at the bottom of the 'Data'A which...

@Faseeh I don't think there is anything wrong with a helper column but it would need to operate from the inputs sheet where the user is not seeing it. The data column is where a user would input data and I am trying to keep all things not related to the inputers interested out of sight. What I...

Have uploaded to https://skydrive.live.com/redir.aspx?cid=b81cfd1b7bf7bb2c&resid=B81CFD1B7BF7BB2C!195&parid=root 1st sheet is a perfect working example of what I want to achieve but I can't seem to get that working outside that simple sheet. Data holds the user inputed data and the 3rd...

Sure, I'm in the office too so will look at uploading tonight. Column A is project Project Steps and holds info like: Grand Average ARCT Average ARCT ARCT ARCT Config Env Average Config Env Config Env Config Env Config Env Imp db Average Imp db Imp db Imp db Imp db Imp db...

That has a different affect anyway :) =IF(OR(LEFT(B8,3)="ART",B8=""),0,INDEX(Data!$A$8:$A$1000,MATCH(0,COUNTIF($AI$14:AI14,Data!$A$8:$A$1000),0))) This time I have a 0 in the first row, 3 unique results only one of which has an ID in the B column, no more of the 12 or so unique results and a...

Thanks for the input Indian, I see the logic in what you're doing there and it's certainly a lot simpler than any way I've been trying it. I am still getting results from rows where the cell in column B has no entry though. In order for the formula to return anything I am having to press...

Hi, I have a table with one column containing a lot of duplicates: 'Data'!$A$8:$A$1000 I want to create a unique column in another sheet which I have done with: =INDEX('Data'!$A$8:$A$1000,MATCH(0,COUNTIF($AI$14:AI14,'Data'!$A$8:$A$1000),0)) The issue I am having is that it has also...

Would love to, but something in that formula wasn't right :) I was trying to use the "<"& before the variable which SUMPRODUCT wasn't having. Got it now with =SUMPRODUCT(('Gantt Chart'!H8:H1000>0)*('Gantt Chart'!I8:I1000="")*('Gantt Chart'!F8:F1000<INT((TODAY()-'Gantt...

Nice one Hui thanks. If I want to add to the array to that to make a case of 'If this cell is greater than 0 and this other cell is blank and a 3rd cell is less that todays week in the project' I would imagine the argument to be, (taking into account Narayan's point about the variable)...

Thanks Narayan, I see the sense in that. Have just gone to test to see if it works but got a surprise when I opened it up here at work, on my XP machine using 2003. Countifs appear to be a no no. Always a challenge, never a chore...except maybe that one. I will test tonight back on 2010...

I'm not sure what I'm doing wrong here but any pointers would be appreciated. I am using the following formula =COUNTIFS('Gantt Chart'!H8:H1000,">0",'Gantt Chart'!I8:I1000,"",'Gantt Chart'!F8:F1000,"<MIN(INT((TODAY()-'Gantt Chart'!AN5)/7)+1)") Value of the date calc is 5 and I...

That works perfect. It makes a lot of sense too, thanks for that. I feel like I've learned 1 or 2 big fancy words in a different language but should be mastering the smaller building blocks of sentences like this kind of stuff. Thanks for your reply Luke.

Hi, I have a chart that is working with a scroll bar, in cell W15 I have the following formula: =INDEX($Q$15:$Q$78,$Z$38) I am now trying to add the ability to switch from viewing one set of data with another using: =OFFSET(W15,0,$W$38) If I am right in how I am interpreting this I need...

Hi, Being new to Excel a lot of this is flying above my head. Using the Gantt chart at http://chandoo.org/wp/project-management/ as a starting point and then building on it I have been learning a lot of basic stuff which is enjoyable. Such as making the chart time aware so that it can autocalc...