Excel Fuzzy Look-up free add-in

Options
Anyone else using the Fuzzy Look-up to help merge spreadsheets?
https://www.microsoft.com/en-gb/download/details.aspx?id=15011


I've had it for Excel 2010 for a couple of months now, and it's a real boon at times, such as two finance downloads - I get separate sheets from PayPal and our own website back-end. Being of modest size, we haven't yet gone for any of the (semi-)automated systems available.


The one limitation I've found so far is that it really doesn't like UK date-format, ie, DD/MM/YYYY and variations thereof. It persists in reading, eg, 10/08/2017 as 8th October, when it is actually 10th August. So I just split the date into three columns and recombine it later.


Other than that, it's a big thumbs-up for a useful tool to have.

Comments

Categories