Hi,

First, I must say that I'm not a VBA programmer and never used excel
much till now. I always wrote R code for manipulating data, but I have
come to believe that excel could save me time when I learned about
things like pivot tables recently.

The one thing that I thought was out of reach for excel was the JOIN()
operation (also called merge() in R)... but then I found this:
http://www.digdb.com/excel_add_ins/j..._tables_lists/

Which works very well. However, the price for the package is a bit
steep for me (an occasional user), and that is the only function I can
see myself using... so that takes me here. Do you know of any freely
available code that implements the JOIN operation for excel (2007 in
my case)?

Thanks!

There is no problem doing a JOIN in Excel in SQL run on sheet ranges.
Look at this NG thread:
http://shorterlink.com/?H5CZPS

RBS

"urlwolf" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> First, I must say that I'm not a VBA programmer and never used excel
> much till now. I always wrote R code for manipulating data, but I have
> come to believe that excel could save me time when I learned about
> things like pivot tables recently.
>
> The one thing that I thought was out of reach for excel was the JOIN()
> operation (also called merge() in R)... but then I found this:
> http://www.digdb.com/excel_add_ins/j..._tables_lists/
>
> Which works very well. However, the price for the package is a bit
> steep for me (an occasional user), and that is the only function I can
> see myself using... so that takes me here. Do you know of any freely
> available code that implements the JOIN operation for excel (2007 in
> my case)?
>
> Thanks!
>

Just out of interest, why not use Access (or SQL Server 2005 Express which
is free and supports Transact SQL) for data manipulation and then export the
results to Excel if you need to analyse them further?

MH

"urlwolf" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> First, I must say that I'm not a VBA programmer and never used excel
> much till now. I always wrote R code for manipulating data, but I have
> come to believe that excel could save me time when I learned about
> things like pivot tables recently.
>
> The one thing that I thought was out of reach for excel was the JOIN()
> operation (also called merge() in R)... but then I found this:
> http://www.digdb.com/excel_add_ins/j..._tables_lists/
>
> Which works very well. However, the price for the package is a bit
> steep for me (an occasional user), and that is the only function I can
> see myself using... so that takes me here. Do you know of any freely
> available code that implements the JOIN operation for excel (2007 in
> my case)?
>
> Thanks!
>