Hi, I work in a medical pathology.
In our Excel database we have medical test turn around times in days in
column L. A "received date" for the test specimen in column J and a specimen
code in column M. I want to calculate the average turn around time (L) for a
test specimen (J) for each month. I am having trouble coming up with a
formula for this to put into a new sheet in a Table-like format with Month
on the vertical and Specimen type on the horizontal. Can anyone give some
pointers for how to write a formula to achieve this?
thanks very much,
Jasen"

"Jasen" wrote in message
...
Hi, I work in a medical pathology.
In our Excel database we have medical test turn around times in days in
column L. A "received date" for the test specimen in column J and a
specimen code in column M. I want to calculate the average turn around
time (L) for a test specimen (J) for each month. I am having trouble
coming up with a formula for this to put into a new sheet in a Table-like
format with Month on the vertical and Specimen type on the horizontal. Can
anyone give some pointers for how to write a formula to achieve this?
thanks very much,
Jasen"



Hi, a small correction....I meant to say: I want to calculate the average
turn-around time (L) per month for each particular specimen type from column
M.
cheers
Jasen

Use Data=Pivot Table Report

If you don't know anything about Pivot Tables, see Debra Dalgleish's site:

http://www.contextures.com/tiptech.html

see pivot tables in the index.

--
Regards,
Tom Ogilvy

"Jasen" wrote in message
...

"Jasen" wrote in message
...
Hi, I work in a medical pathology.
In our Excel database we have medical test turn around times in days in
column L. A "received date" for the test specimen in column J and a
specimen code in column M. I want to calculate the average turn around
time (L) for a test specimen (J) for each month. I am having trouble
coming up with a formula for this to put into a new sheet in a Table-like
format with Month on the vertical and Specimen type on the horizontal.
Can anyone give some pointers for how to write a formula to achieve this?
thanks very much,
Jasen"



Hi, a small correction....I meant to say: I want to calculate the average
turn-around time (L) per month for each particular specimen type from
column M.
cheers
Jasen

"Tom Ogilvy" wrote in message
...
Use Data=Pivot Table Report

If you don't know anything about Pivot Tables, see Debra Dalgleish's site:

http://www.contextures.com/tiptech.html

see pivot tables in the index.

--
Regards,
Tom Ogilvy

Thanks Tom, will give it a try and let you know if that works.



"Jasen" wrote in message
...

"Jasen" wrote in message
...
Hi, I work in a medical pathology.
In our Excel database we have medical test turn around times in days in
column L. A "received date" for the test specimen in column J and a
specimen code in column M. I want to calculate the average turn around
time (L) for a test specimen (J) for each month. I am having trouble
coming up with a formula for this to put into a new sheet in a
Table-like format with Month on the vertical and Specimen type on the
horizontal. Can anyone give some pointers for how to write a formula to
achieve this?
thanks very much,
Jasen"



Hi, a small correction....I meant to say: I want to calculate the average
turn-around time (L) per month for each particular specimen type from
column M.
cheers
Jasen

Thanks Tom, works well......but how can you exclude some data within a
column?

"Tom Ogilvy" wrote in message
...
Use Data=Pivot Table Report

If you don't know anything about Pivot Tables, see Debra Dalgleish's site:

http://www.contextures.com/tiptech.html

see pivot tables in the index.

--
Regards,
Tom Ogilvy

"Jasen" wrote in message
...

"Jasen" wrote in message
...
Hi, I work in a medical pathology.
In our Excel database we have medical test turn around times in days in
column L. A "received date" for the test specimen in column J and a
specimen code in column M. I want to calculate the average turn around
time (L) for a test specimen (J) for each month. I am having trouble
coming up with a formula for this to put into a new sheet in a
Table-like format with Month on the vertical and Specimen type on the
horizontal. Can anyone give some pointers for how to write a formula to
achieve this?
thanks very much,
Jasen"



Hi, a small correction....I meant to say: I want to calculate the average
turn-around time (L) per month for each particular specimen type from
column M.
cheers
Jasen

Where? in the pivot Table? Select the dropdown at the top of that column
and unselect items.

--
Regards,
Tom Ogilvy

"Jasen" wrote in message
...
Thanks Tom, works well......but how can you exclude some data within a
column?

"Tom Ogilvy" wrote in message
...
Use Data=Pivot Table Report

If you don't know anything about Pivot Tables, see Debra Dalgleish's
site:

http://www.contextures.com/tiptech.html

see pivot tables in the index.

--
Regards,
Tom Ogilvy

"Jasen" wrote in message
...

"Jasen" wrote in message
...
Hi, I work in a medical pathology.
In our Excel database we have medical test turn around times in days in
column L. A "received date" for the test specimen in column J and a
specimen code in column M. I want to calculate the average turn around
time (L) for a test specimen (J) for each month. I am having trouble
coming up with a formula for this to put into a new sheet in a
Table-like format with Month on the vertical and Specimen type on the
horizontal. Can anyone give some pointers for how to write a formula to
achieve this?
thanks very much,
Jasen"



Hi, a small correction....I meant to say: I want to calculate the
average turn-around time (L) per month for each particular specimen type
from column M.
cheers
Jasen