Search results

Hi Narayan and the rest of the group. I just wanted to say thankyou to you all for all the help. I have however cracked it and it seems to work. It doesn't involve any complicated formulas except look up's and TRUNCs. In order to make it work I had to re-think it and this is what I did as...

Oh and No it doesn't need to be until 2029, next 5 years is fine lolol

Hey Naray That is indeed correct, the example spreadsheet is a lot smaller than the actual version since there are approx 20 projects. At the moment I have been manually mapping the data onto the weekly calendar and with so many projects I was hoping to create some formula's to make it more...

Ive had a good long hard look at all this and beginning to think that maybe its just not possible.....ahhhhhhhhhh

Hello again all I may be doing something wrong here.....but for some obscure reason the formula is not picking up all of the data, for example Tab 1 is picking up the text Task 1 project 1 for example but is not picking up the text PMC project 1 , PMC 2 project 1 but is picking up the text PMC...

Well I just want to say how wonderful you all are here..... You really are truly brilliant. Many Many thanks for your help, Oh and sorry it took so long to reply....I have been working on this spreadsheet for sometime now, and this is the last bit... Also, in order to understand the...

Nope Im still stuck, I just cannot seem to get the formula's to work, now maybe Im just being stupid, but any help would be gratefully appreciated, Im now starting to tear my hair out...and don't wish to go bald at such a (youngish) age .

Good morning all Here is a link to an uploaded file: http://hotfile.com/dl/130170344/ee46c1f/Project_calender_and_dates.xlsx.html

Oh my goodness you are wonderful..... and thanks for replying so quickly. You are quite right in that tab 2, the date and the data adjacaent to that date is indeed in its own column. So....I am going to give this a whirl and have a look over the weekend and see how I get on. I have done a...

Well good afternoon all So I could do with some serious help. after approx 5 hours I still haven't cracked it, and Im at a loss so any help would be appreciated. I am not an excel whizz and bear in mind this needs to be done with forumlas only (i.e. no macros) so...here we go. I have 1...