Comparing List and sort

[ajmal pottekattil yoousuf]

Comparing a List of Companies and sorting in a table.

please refer the attachment.

[#2]

@ajmal pottekattil yoousuf 

Can you explain what you want?

[#3]

@Hans Vogelaar 

One List is Mentioned as "Venktron Electronics L.L.C."
Another User Enter is "Venktron Electronics Co. Ltd."
So we can't compare the list.
But both are the same company.

We want to compare the list. if the Name is the same one flag statement is required.

[#4]

@ajmal pottekattil yoousuf 

Perhaps you can use the free Fuzzy Match Add-In from Microsoft

[#5]

please Guide me how to use this function.
I am first time hear about this function.

[#6 · Accepted solution]

@ajmal pottekattil yoousuf 

See for example How to use the Fuzzy Lookup add-in in Microsoft Excel 

[#7]

Thanks for the Guidance.