0

I have two tables of data with 5 columns - Name, Phone Number, Email Address, Post Code and Order Time. Both tables have around 10,000 rows. I need there to be an exact match on Name, Phone Number, Email Address and Post Code and a fuzzy match on order time - as the order times can be off from a few seconds to a few minutes in both sets of data. I want to be able to reconcile orders on both sets of data allowing for a time window.

I have created two sets of tables for both datasets and ran the fuzzy lookup with 5 separate matching columns - 4 of them exact matches on Name, Phone Number, Email Address and Post Code and a default fuzzy match on the Order Time. However when I run the fuzzy lookup I get a memory timeout error at about 300 rows. Does anyone know how I could resolve this? I have a 8gb memory machine but I’m not sure if increasing the memory will fix this.

Thanks

Improve this question
4
  • Hi and welcome to SU. What version of Excel are you using?
    – FlexYourData
    Commented Jun 25, 2020 at 10:40
  • Hi! I'm using Excel 365
    – Tom Keenan
    Commented Jun 25, 2020 at 10:42
  • You can explore ways to use fuzzy matching via Merge through Power Query: support.microsoft.com/en-us/office/… (I suspect your use case makes this not an option). Or review the options here: stackoverflow.com/questions/42839412/…
    – FlexYourData
    Commented Jun 25, 2020 at 10:49
  • Thanks! I've looked into Power Query and it doesn't seem applicable to this use case - as you thought. I looked into the topic discussed in the link above and im doing everything suggested but still i get the timeout.
    – Tom Keenan
    Commented Jun 25, 2020 at 14:44

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .