Fuzzy Matching with Fuzzy Date help MATCHING

[aurorajones]

Hi

i need help in identifying a fuzzy matches and fuzzy dates

I have
Column A which has a client parent group,
Column B which has product names, but they can be about 40% accurate e.g Apples can also be fiji apl
Column C that has order start date
Column D that has order end date
Column E that has fruit order 1
Column F that has fruit order 2

(each row has either Order 1 or 2, but never both becuase of the product names being fuzzy)

Basically, I need to find for each client which Products names (e.g. Apple and fiji apl) appear in Order 1 & 2, within 14 days of the start date and 14 days of the end date.


I'm completely lost on how to do this correctly without going to an array.

[azumi]

Maybe more clearer if you upload your sample workbook at the forum would you? and explain the desire results too...

to attch your excel file:
Click "Go advanced" button next to "Post Quick Reply" and find paperclip button to attach you file....

Thanks