Could you expand on the pivot table, I have never gotten them to work.

Thanks.

"Jan Karel Pieterse" wrote:

Hi Lost,

What I would like is to have a running total of blood cultures per patient
and per rec date.

This calls for a pivot table.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com