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