Unique count

[Gilles Desjardins]

Hi everyone, I have a unique count question.

Patient Day Test
120 7 pass
134 7 pass
120 7 fail
120 90 pass
120 90 fail
119 90 pass

Using the above table I wish to count patient # 120 only once when he failed
a clinical test on different days. Any help will be greatly appreciated.

Gilles

 

[Bernard Liengme]

Chip has lots of useful stuff for finding/counting unique items:
www.cpearson.com
Bernard

 

[Gilles Desjardins]

Thank you Bernard, I looked there first, then John Walkenbach's site, then
Mr. Excel, etc. no luck for what I want to do.
Waiting for another idea
Gilles