• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need extract a common value from multiple cells

udprocks

udprocks

Member
Hi,

I need to extract data from two cells that is common value in both cells .

i have attached a sample sheet for same.

any help much appericiated.
 

Attachments

  • string.xlsx
    9.4 KB · Views: 14
Hi,

IF you allow us to add 3 extra column to get the numerical value of the data
you can use the attached file formula to get your desired result
here I also believe that your string of all numerical value will be one after another

regards
Naresh
 

Attachments

  • exact Match.xlsx
    10.6 KB · Views: 8
Naresh Yadav said:
Hi,

IF you allow us to add 3 extra column to get the numerical value of the data
you can use the attached file formula to get your desired result
here I also believe that your string of all numerical value will be one after another

regards
Naresh
Click to expand...

thanks naresh, its cool working for me.
 
Hi,

if all the text text string is lower case than this is what I have
pls find the attached file for your understanding

regards
Naresh
 

Attachments

  • abcdef.xlsx
    12.5 KB · Views: 12
I misread the requirement, most probably.
Which result is accurate
abc1da1f ---> a1a1a1a1a1a = 11111 (digit is found so report it)
abc1da1f ---> a1a1a1a1a1a = 11 (matching digit, count)
abc1da1f ---> a1a1a1a1a1a = 1 (matching single max case)

I thought third as requirement. Here's a formula which will give you maximum match number which needs to be entered by CSE.
=MAX(IF(ISNUMBER(FIND(MID(B2,COLUMN($A$1:INDEX($1:$1,LEN(B2))),ROW($A$1:INDEX($A:$A,LEN(B2)))),A2))*ISNUMBER(--MID(B2,COLUMN($A$1:INDEX($1:$1,LEN(B2))),ROW($A$1:INDEX($A:$A,LEN(B2))))),--MID(B2,COLUMN($A$1:INDEX($1:$1,LEN(B2))),ROW($A$1:INDEX($A:$A,LEN(B2)))),0))
 
shrivallabha said:
I misread the requirement, most probably.
Which result is accurate

abc1da1f ---> a1a1a1a1a1a = 1 (matching single max case)

I thought third as requirement. Here's a formula which will give you maximum match number which needs to be entered by CSE.
=MAX(IF(ISNUMBER(FIND(MID(B2,COLUMN($A$1:INDEX($1:$1,LEN(B2))),ROW($A$1:INDEX($A:$A,LEN(B2)))),A2))*ISNUMBER(--MID(B2,COLUMN($A$1:INDEX($1:$1,LEN(B2))),ROW($A$1:INDEX($A:$A,LEN(B2))))),--MID(B2,COLUMN($A$1:INDEX($1:$1,LEN(B2))),ROW($A$1:INDEX($A:$A,LEN(B2)))),0))
Click to expand...
dear sir,

exactly third one is requirement like
its work like charm....

thanks you so much ,...:)
 
You must log in or register to reply here.
Back
Top