+ Reply to Thread
Results 1 to 13 of 13

How to Compare More Than Two Cells String and assign the % of Comparison Value Among the L

  1. #1
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    277

    How to Compare More Than Two Cells String and assign the % of Comparison Value Among the L

    Dear Experts,

    Attached Lists “Column A” Contains Different Product Lists. I would need a Formula or a VBA Program, which compares all Data listed down in “Column A” and Commonality percentage against Each Product to be written on Column B.

    Need your suggestion on the same!

    Thanks & Regards,
    Rajeshkumar R
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    277

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    Dear Experts,

    Is there any additional information required on above my Request?

    Thanks & Regards,
    Rajeshkumar R

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    14,338

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    Simply clearly... don't understand what you are trying to do...

    What is your expected result?

  4. #4
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    277

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    Dear Jindon,

    Thanks for your Response! Let me try to explain with little more clarity here!

    Please find a Revised Attachment, Column A Contains Group 1 to 7,

    In Group 1, There are 24 Different List of Product, Each Product Description Contains different length of Character!

    B2 Text contains 55 Character & B3 Text contains 64 Character,

    Between These two texts, “HS0001 HARNESS ASSY MX INC/SISTEMALUX 1326488” common (Length of Character is 45 Words)

    So,

    C2 Results I would want 45/55=82%
    C3 Results I would want 45/64=70%

    Likewise, all 24 Products in Group 1 To be compared each one with other and Comparison Result has to be updated in Column C.

    Same comparison to be executed for Group 2, 3,4, 5 and So On…

    Looking Forward Your Valuable Suggestion!

    Thanks & Regards,
    Rajeshkumar R
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    14,338

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    Still not clear to me.

    Take group1, B2, B3 is understandable, but what about the rest?
    B2 to B4, B2 to B5... all within the same group and then
    B3 To B4, B3 to B5..etc?

    I mean one to many or one to one.
    You will need to add the result for col.C to show us how to calculate and why.

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    5,829

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    I have done this manually but is this what you're looking for ?
    Attached Files Attached Files
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  7. #7
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    277

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    Dear bakerman2,

    Yes, You are absolutely Right! That is what Exactly I am looking For! Could you please help me with a Macro or a Formula which will helps to auto update the desired Results!

    Note : My Live File contains more than 10K+ Rows, So your suggestion would really help me a lot!

    Thanks & Regards,
    Rajeshkumar R

  8. #8
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    277

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    Dear Friends,

    Any positive Progress on my subjected Request!

    Thanks & Regards,
    Rajeshkumar R

  9. #9
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    5,829

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    you are talking about 10K rows so to be honnest I don't see this happening. There are too many variables to form groups that it would take that much calc power your computer might run multiple hours to calculate.

    i.e if you look at rows 148 to 157 they have a high percentage of match. Then there's 8 rows that don't match and then again 10 rows that match the first group. Are they considered to be 1 group or treated as a seperate group ?

    If you would be able to overcome that then next you would have to loop through each item in a group to determine how many characters match to have a base in order to be able to make the calculation you require.

  10. #10
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    277

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    Dear bakerman2

    you are talking about 10K rows so to be honest I don't see this happening. There are too many variables to form groups that it would take that much calc power your computer might run multiple hours to calculate. ======= Yes, I agree with you!

    i.e. if you look at rows 148 to 157, they have a high percentage of match. Then there's 8 rows that don't match and then again 10 rows that match the first group. Are they considered to be 1 group or treated as a separate group? ======= Group Remains unchanged!

    If you would be able to overcome that then next you would have to loop through each item in a group to determine how many characters match to have a base in order to be able to make the calculation you require. ======= Could you please help me in suggesting How to loop Through and achieve what I am looking for?
    To Overcover the 1st Concern which You raised, regarding 10K+ Rows Comparison, I would load 1K Rows of data in 1 Short and get the output. Similarly, I shall Repeat the Activity for 10 Times. Which would still helpful for me!


    Thanks & Regards,
    Rajeshkumar R

  11. #11
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    277

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    Dear bakerman2,

    I found below link some input which is similar to my expectation, But due to my lack of knowledge in VBA, I am unable to understand. Could you please review and provide an suggestion which suits my requirement!

    https://www.excelforum.com/excel-gen...ercentage.html

    Thanks & Regards,
    Rajeshkumar R

  12. #12
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    277

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    Dear Experts,

    Looks like the above criteria is not process-able!

    I have just attached an Revised Attachment, Here what I want here is, Let A2 Cell Value Compare with all cells column in Column A which contains Data (Excluding Current Cell) and Provide the Max Percentage value among comparison in Colun B

    Then, same comparison let it get executed for all cells with Data!

    Looking for your valuable suggestion Please!

    Thanks & Regards,
    Rajshkumar R
    Attached Files Attached Files

  13. #13
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    277

    Re: How to Compare More Than Two Cells String and assign the % of Comparison Value Among t

    Dear Experts,

    Could you please help me with an suggestion on my Previous Post?

    Thanks & Regards,
    Rajeshkumar R

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1