Recent content by Dave_P

Hi Narayan, okay, that seems great. but i have no idea how i would do that? lol. that really is drilling down the info. I was going for a very simple idea. just as the data was completed in the last cell. so if cells 1 -7 had data then just average the number in "days to production" i...

RFQ IN RFQ OUT QUOTE In QUOTE REP JB IN JB OUT DAYS TO PRODUCTION 5/07/13 5/08/13 5/09/13 10/10/13 11/11/13 12/12/13 115 5/07/13 5/08/13 10/09/13 1/12/13 106 5/07/13 1 HI Narayan, as above, so i wanted the...

i tried =AVERAGE(Table2[DAYS TO PROD]) which gives a false result. i would like a cumalitive result as the jobs increase. meaning as the rows fill. wow this hard to explain!

thank you Narayan. will have a look around. one more question, formula for I2 is great. how would i do the average for g2: g16 etc etc

thank you narayan, i sincerely appreciate your help. I'll do some research on your formula to understand it better, that said i would really like to learn more about excel and look to do a course with chandoo! where would you suggest a good place to start? kind regards dave

Hi Narayan, Yes your correct on all of your points. I would like to exclude weekends, sat and sun and public holidays where possible. thank you

Hi Narayan, thank you for your patience, this is new to me. there will be 1 - 7 cells with dates inputed into them. what i wanted was one cell that calculated the time in days between the dates and gave a result of "x" days from start to end.so as the job progressed the total days would...

Hi Friends, I'm just starting out with excel and i have researched a formula but it doesn't seem accurate its oftern a day or two out. what i wanted to achieve was the time it takes to deliver a product from th eday the quotation took place. so i have 5 cells that have data that will show...