Search results

Thanks, XML seems to sort it, but I don't like that 'generated' column that is automatically created.

This is a now cross posted here: http://www.mrexcel.com/forum/excel-questions/698718-what-%91best%92-way-import-data-into-excel-access.html#post3453005 Sorry for being a little impatient, but I hoping to sort this as soon as possible, as I can't carry on with the rest of the db until this...

What is the ‘best’ way to import data into Excel from Access? I’m using Excel 2003 and I’m importing data that has been exported from an Access database (as an xls file), the data has the following fields: 1. Event (String) 2. Start Date 3. End Date An ID is always present as is a START...

Many thanks for your efforts, I only just noticed your last response, I didn't think you'd work so fast! Brilliant. I see your solution is centred around identifying keywords and then using those to group the measures. I really like your idea of organising the text to help filter and identify...

I edited it (from 46,000+ rows!) and - as you may have realised - removed some text from the metrics indicator column. Column C is just the Indicators column anomolysed (slightly!), it's not in the actucal working file. Thanks :)

I've just checked. It's still available at: https://rapidshare.com/#!download|92p8|980583197|Fuzzy%20Problems.xlsx|369|0|0 or https://rapidshare.com/files/980583197/Fuzzy Problems.xlsx Just select the green download box. Thanks for any help.

Yes, it should still be available. don't trust the link, you need everything in the brackets.

Now that the problem is understood, I was hoping that someone may give me an idea how to organise the data or have a process/formulae to help achieve my objective (to group the measures). I realise that the fuzzy match algorythm will never be perfect, I trialed a few different permatations, but...

Okay. Check out: (https://rapidshare.com/files/980583197/Fuzzy Problems.xlsx) Thanks.

Thanks for the welcome. I've not been able to find a soloution online. To use my example, my problem is that the fuzzy match has successfuly matched Org1's bananna measure to similar measures in other organisations, but its not found Org 5's measure. That's because it's not met the match...

Yes I can upload an extract tomorrow. Thanks.

Many thanks for the reply. I'd considered keywords, but there are so many diverse measures, that it'd take forever to define a set of keywords, there are perhaps over 1000 unique measures and I don't even understand what all of them are about. My initial thought was to give each different...

I'm based in the UK and have used this site for a year or so. I was that engrossed in the articles that I only recently realised there was even a forum! I used to consider myself as 'intermediate' in Excel, but this site blows my mind! There is so much to learn, I'm maybe an 'advanced novice' :)...

Hi all, I recently posted this on Mr Excel, but I've not had a reply in 48 hours so I thought it safe to see if anyone here at Chandoo could help. Hope someone can! This is a tough one to explain, but I’ll do my best as I’ve not found anyone who can offer a solution. I have a list of...