I am working on some genetic project, I have a column contain all the data with the gene name, which may come in a cluster in a cell, and i have a list which contain the gene i am interested, for example
Column B (gene list interested)
PCNA
GADD45G
bActin
p21
Column A (look up array)
PCNA;PCNA;p53
p53;p21
SOC2;SOC2
GADD45A
I want it return true if the string in column A contain any of the gene name in column B.
I can only come out a formula =isnumber(match(A2,B:B,0))>1 which returns only an exact match. what formula can i use to return if it contains any of the gene listed in column B?
see attatchment
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Thankyou so much for your quick reply!!
but what is the double -- sign in front of isnumber function for?
it is converting logic into number. for detail learining visit
http://www.xtremevbtalk.com/showpost...33&postcount=5
It is recommended to always use evaluate formula option in the formula tab in order to understand the formula
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Thank you so much!! problem solved!!
o no...there is still one problem...how can change the prefix to solved =.="?
Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.
Kindly also read forum rules
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks