how to run and if then with a replace?
 

have three things in three columns, A, B,c.
The first is a letternumber combination, i.e.
a-1
a-1
a-1
b-1
b-1
b-1
The second is the object in question for a-1, so: test1, test2, test3
which is repeated for b-1. Some tests are positive, and designated by a
1 for + and a 0 for negative in column C. However, if there is a
positive for any test, i need all of the test results to be displayed
(the results are in column D). Right now, with some help, i can get
excel to read the information and output all results that have a 1 on a
second sheet.


How could i get excel to see which results are positive and the output
all results (the column D numbers) to a sheet. Maybe a vllokup of the
values on column d that replaces the 0 in sheet one with a 1?
thanks,

See a recent reply to your post from last night.

Biff

-----Original Message-----
have three things in three columns, A, B,c.
The first is a letternumber combination, i.e.
a-1
a-1
a-1
b-1
b-1
b-1
The second is the object in question for a-1, so: test1,
test2, test3
which is repeated for b-1. Some tests are positive, and
designated by a
1 for + and a 0 for negative in column C. However, if
there is a
positive for any test, i need all of the test results to
be displayed
(the results are in column D). Right now, with some help,
i can get
excel to read the information and output all results that
have a 1 on a
second sheet.


How could i get excel to see which results are positive
and the output
all results (the column D numbers) to a sheet. Maybe a
vllokup of the
values on column d that replaces the 0 in sheet one with
a 1?
thanks,

.