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