Approximate match in columns to merge along with amount

sleek12

New Member
Joined
May 3, 2014
Messages
29
Debtor
Amount $
X Insurance ltd
5800
X Ins. Ltd
-480
X Insurance Brokers Ltd
4700
X Ins. Brokers ltd
-950
Y Enterprises
8900
Y Ent Ltd
950

<tbody>
</tbody>
Objective: I have fuzzy logic in my excel but it compares 2 columns , but i have inexact data in debtors list, (rules of prevention of database duplication were not followed), is there a way a macro or a combination in fuzzy logic that i can have these results :-
SOLUTION:
X insurance Ltd:
5800-480+4700-950=$9070.00
Y Enterprises: 8900+950=$9850.00
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

AFPathfinder

Well-known Member
Joined
Apr 8, 2012
Messages
519
If you're talking fuzzy string comparison, this is an amount of risk that the result could be false. Some function like VLOOKUP allow approximation, but I've never tried that on text.

VBA can offer a solution, but you'd need to build your own string comparison or adapt another person's solution to your situation, such as in this post: http://www.mrexcel.com/pc07.shtml

I've seen others that have kept a repository table that the value is checked against. If the value exists, the second column has a default value for that person/client/company/etc. If the value doesn't exist, the user adds it to the list along with a default value for reference next time.
 

sleek12

New Member
Joined
May 3, 2014
Messages
29
Yes, i actually would like to look at the probability level !! and still discern from thereon !!!
 

Watch MrExcel Video

Forum statistics

Threads
1,123,481
Messages
5,601,918
Members
414,482
Latest member
morkar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top