I’m sending you an e-mail with the workbook so that you can attach it here if you -įirstly, let me say I appreciate your comment and your support of my blog. Needless to say, the power of SQL and the range of the new possibilities that it brings to the table creates a brand new platform of its own.
#Compare two columns in excel for partial matches code#
The essential procedure is about 10 lines of VBA code which makes it a lot shorter than your initial solution and roughly on-par with the optimized version. I use “Microsoft ActiveX Data Objects 2.5” but any newer version will work as well.Įverything resides in the same workbook you provided in first place.
The only trick is to include a new reference (via Tools/References in Office 2003) to the ADO object library.
There aren’t any special requirements or (God forbid) installations. I’ve re-written the solution using ADO and the, so called, “Jet Engine” (think Access). In fact, combining the power of SQL and Excel is much simpler than what is widely expected. But then you asked “How do we do this in Excel?” and it sounded as if there was no point trying to do it the right way using SQL. Besides, by including the sample SQL statement you most likely had similar thoughts of yours. My problem is that data manipulations like those tend to push Excel’s envelop a bit too far and probably belong to a completely separate domain (ie databases and SQL). I do realize that your approach (and especially the optimized version) gets the job done and many Excel fans will be quite satisfied with the result. The only downside is that we might become addicts and expect nothing short of miracles with every new entry of yours.įor the mere sake of quality I’d like to share some thoughts about today’s topic. As a fan of yours, I’m already used to the amazing creativity of your solutions and the high quality of the resulting apps.
0 kommentar(er)
