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

Dear Experts,

Is there any additional information required on above my Request?

Thanks & Regards,
Rajeshkumar R

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

What is your expected result?

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

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.

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

Dear Friends,

Any positive Progress on my subjected Request!

Thanks & Regards,
Rajeshkumar R

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

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

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

Dear Experts,

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

Thanks & Regards,
Rajeshkumar R