Search results

Dear Hui That is exactly what I wanted, sorry I couldn't explain it better first time! I just wish I could write such a formula.... :( Thanks for all your help Kinesh

Dear Hui I have tried your formula as well and the same issues arise as with my post to Nazmul. Can you help further? Any comments very gratefully received.

Dear Nazmul Thank you for your formula. I can't get this to work. I've uploaded a part of the actual Excel 2010 sheet at: https://docs.google.com/open?id=0Bx3oFxTuITDXakxsaE8tY0V3UFk You can download it by clicking File-Download If you type 2010 into E2 it does not work. I also...

Thanks Nazmul and Hui The results I would expect for year 1 average for John Smith would be 3.2 (AVERAGE(c3:c22)) and 4 for his year 2 average (AVERAGE(C23:C28)). It should not be possible to calculate a year 3 average as he does not have 3 years of data. I have added these to the sheet above...

Thanks for the reply Some sample data would be: https://docs.google.com/spreadsheet/ccc?key=0Ah3oFxTuITDXdDBOMnI3SXJRci1mY1lFZTQ1V2FnLWc I would like John Smith's drug average drug doses for year 1 and year 2 from 1/3/10 but Jack Hunter's year 1 and 2 average doses from 3/7/10. I can't...

So for doctor A, the first date may be 1/3/2008. I want to know the average dose of drug given from there for each year time period from this date. Doctor B may start at a different date however, so the date range needs to be calculated from the first time a doctor's name appears. Getting the...

I hope you can help! I have a list of doctors names in column A I have a list of dates in column B I have a list of drug doses they have given in column C I want to work out the average drug dose for each doctor for each year time period since the first date recorded on the system. For...