Approximate match in columns to merge along with amount

[sleek12]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Debtor
[/TD]
[TD]Amount $
[/TD]
[/TR]
[TR]
[TD]X Insurance ltd
[/TD]
[TD]5800
[/TD]
[/TR]
[TR]
[TD]X Ins. Ltd
[/TD]
[TD]-480
[/TD]
[/TR]
[TR]
[TD]X Insurance Brokers Ltd
[/TD]
[TD]4700
[/TD]
[/TR]
[TR]
[TD]X Ins. Brokers ltd
[/TD]
[TD]-950
[/TD]
[/TR]
[TR]
[TD]Y Enterprises
[/TD]
[TD]8900
[/TD]
[/TR]
[TR]
[TD]Y Ent Ltd
[/TD]
[TD]950
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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

 

[AFPathfinder]

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]

Yes, i actually would like to look at the probability level !! and still discern from thereon !!!