• 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.

Match two columns of excel and show the difference in percentage

anuwers

Member
Dear Friend,

Need to match two columns of excel and need to know the result in percentage in third column.

Example:
Coloumn A Column B Column C
Patrick Joseph Patric Joseph lets say 90%
Andrew lincon Anrew lincon 85%
Anwar Chaudhry Nafees Ahmed 0%
Siddiq Jamal Jamal Siddiq 50%

VBA CODE required to do this type of matching for more than 50000 records.

You may decide the percentage. Expectation is difference of both columns to appear with percentage.
 
Just a guessing challenge as you forgot to share how do you calculate the percentage and as guessing can't be coding …​
 
Power Query fuzzy matching will do this. Attach a workbook with realistic data to work with.
 
In the attached, update your table on the left, then right-click in the right hand table and choose Refresh.
 

Attachments

  • Chandoo50747Match Percentage.xlsx
    17.6 KB · Views: 11
Back
Top