Comparing List and sort

Frequent Contributor

Comparing a List of Companies and sorting in a table.

please refer the attachment.

6 Replies

@ajmal pottekattil yoousuf 

Can you explain what you want?

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

@ajmal pottekattil yoousuf 

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

please Guide me how to use this function.
I am first time hear about this function.
best response confirmed by ajmal pottekattil yoousuf (Frequent Contributor)
Thanks for the Guidance.