Finding Closest Data Match

[Closed]
Report
Posts
6
Registration date
Sunday February 1, 2015
Status
Member
Last seen
April 29, 2015
-


I am looking for the some help doing the following. Assume each cell in Column B is the target cell, and the data in Column A is to be interigated to find the closest match and return the result from Column A into the adjacen cell in Column C. It is possible the the amount of cells in Column A and B can vary based on the example. Each charecter in the string of charecters should be evaluated for the best match to the target. (maybe assign a 1 or 0 to each that match or don't match, then sum up for the highest value) I can send the raw data if you give me your email address.