If you want to identify the patients, you could use:
=IF(COUNTIF(B$3:B4,B4)=1,1,"")
in Q4 and copy down. That will output a 1 against their first admission.
If you want to get the data for a given month, things get more complicated.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|