Excel functions and programming

[Jasen]

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]

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]

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.

 

[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.

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

 

[Jasen]

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

 

[Tom Ogilvy]

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