Hi,
Capture.JPG
I have set of numbers (alphanumeric actually) separated by comma in cell B2 and another set of numbers separated by comma in cell C2.
If any of the number in cell C2 matches to the number in cell B2, then I want "Yes" in cell D2. In other words, if there is any common number, then I want Yes in cell D2.
Can you please let me know the formula?
Thank you in advance, Good day.
Last edited by Prascena; 11-20-2021 at 02:21 PM.
Read the yellow box on top of this page.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Just did, sorry
Please try
=IF(COUNT(SEARCH(","&TRIM(MID(SUBSTITUTE(C2,",",REPT(" ",99)),(ROW(Z$1:Z$20)-1)*LEN(C2)+1,LEN(C2)))&",",","&B2&",")),"Yes","No")
Works great!! Thank you muchOriginally Posted by Bo_Ry
Hello, I'm facing some issues. I find output incorrect in some cells
We are unable to determine what your issues are unless you tell us. We cannot see what you see and we do not read minds. Tell us specifically what is wrong so it can be analyzed and a better solution provided.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hello,
Can anyone help me with formula to get the Output (Column C in attached excel)
Column A and Column B have some numbers (Alpha Numeric) separated by comma. If they have any common number, then I need Column C value to be "Yes" and if not I need value to be "No".
Can anyone help with this? The last code didnt work and though there were common items between Col A and Col B, still the result was saying "No"
Thank you in advance.
=IF(COUNT(SEARCH(","&TRIM(MID(SUBSTITUTE(A2,",",REPT(" ",99)),(ROW(Z$1:Z$99)-1)*LEN(A2)+1,LEN(A2)))&",",","&B2&",")),"Yes","No")
=IF(COUNT(SEARCH(","&TRIM(MID(SUBSTITUTE(B2,",",REPT(" ",99)),(ROW(Y$1:Y$99)-1)*LEN(B2)+1,LEN(B2)))&",",","&A2&",")),"Yes","No")
Hello thank you!!
May I know why is that two formulas are there and you have added two columns in the attachment? I just need "Yes" if there is any number common number existing between col A and B and "No" if it doesnt. Is that possible?
Thank you for helping
Attachment 756524
See above, there is a common number available, but output says "No". Can this issue be fixed?
Thank you.
The attachment is not visible. Suggest you upload a picture or the file showing what the attachment is meant to show.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks