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