multiple search

N

Neska

I have a worksheet with three columns in the first column I have All the
entries for things that go up in one experiment (ex. BI879444). In the second
colum I have all the entries that were analaized an in the third column is
the related name for each entry. I want to multiple search all the values
from the first column in the second and mark them or sth like that any one
can help me. I do not now to much of excel so be patient
 
M

Max

Assuming data in cols A to C from row2 down
and you want to compare col A with col B
Put in D2:
=IF(ISNUMBER(MATCH(A2,B:B,0)),"Y","")
Copy down to the last row of data in col A. Then just autofilter on col D
for "Y". These will be the lines where col A's items are found in col B.
 
N

Neska

Neska said:
I have a worksheet with three columns in the first column I have All the
entries for things that go up in one experiment (ex. BI879444). In the second
colum I have all the entries that were analaized an in the third column is
the related name for each entry. I want to multiple search all the values
from the first column in the second and mark them or sth like that any one
can help me. I do not now to much of excel so be patient
Click to expand...
So I tried what you told me =IF(ISNUMBER(MATCH(A2,B:B,0)),"Y","")
So imagine I have in colum A 100 cells with data (ex BI879444) and in column
B this 100 data mixed with 1000 more. What will be the exact formula if it
start in A2. And what it means to search for Y. Sorry I do not know much
about excel. Thanks for your help
 
M

Max

Neska said:
So I tried what you told me
=IF(ISNUMBER(MATCH(A2,B:B,0)),"Y","")
So imagine I have in colum A 100 cells
with data (ex BI879444) and
in column B this 100 data mixed with 1000 more.
What will be the exact formula if it start in A2.
Click to expand...

Use the same expression. As suggested, put it in D2, then copy D2 down to
the extent of data in col A
And what it means to search for Y...
Click to expand...

The expression returns/"marks" an arb. flag "Y" where col A's items are
found in col B. The flag "Y" allows you to then use autofilter to easily
filter out the rows.
 
Top