Biff

I read it as OP wants all records for a patient including negative records
if a patient has at least one positive record.

Probably have to filter a couple times.

Too late for thinking right now.............night all


Gord

On Sat, 26 Jul 2008 22:22:35 -0400, "T. Valko"
wrote:

Use autofilter and filter on positive. You can copy the results and paste
into a new sheet if you want.

--
Biff
Microsoft Excel MVP


"jimbo" wrote in message
...
I have a list of people with test resullts. I need to identify the
infividuals who are positive, and list all of their results, e.g. in
the following example, I would want all of the results of john smith
and mary kay because they have one or more positive results, but not
any of the results of jim jones or susan rae, because all of their
results are negative. This is easy enough when there is a limited
number of individuals, but when it is in the 10s of thousands, it's
impossible for me to capture anything more thatn the positive from a
single date. But I need all of the results of any individual with one
or more positives. Any suggestions?
john smith 3/4/2008 negative
john smith 4/4/2008 positive
john smith 5/4/2008 negative
john smith 6/4/2008 negative
john smith 7/4/2008 negative
jim jones 3/4/2008 negative
jim jones 4/4/2008 negative
jim jones 5/4/2008 negative
jim jones 6/4/2008 negative
jim jones 7/4/2008 negative
mary kay 3/4/2008 negative
mary kay 4/4/2008 negative
mary kay 5/4/2008 negative
mary kay 6/4/2008 positive
mary kay 7/4/2008 negative
mary kay 8/4/2008 negative
susan rae 5/4/2008 negative
susan rae 6/4/2008 negative
susan rae 7/4/2008 negative
susan rae 8/4/2008 negative