Actually SQL is an option:

http://www.erlandsendata.no/english/...php?t=envbadac

If using ADO, you shouldn't query from an open workbook. A solution is to
do

Activeworkbook.SaveCopyAs Name

then query against that copy, then you can Kill it when done.

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
Dear experts,

In excel, I have to find the differences between two sets of data.
Just like your set theory from grade 9 .

In one set, I have, say,

A
B
C
D
E
F

In the other set, I have,

D
E
F


Set one, minus set two is:
A
B
C


I would like to put the results of the minus into a new column.


In sql, you would just:

Query1
minus
Query2

But database is not an option here. The data is only in the
spreadsheet.


How can I do the same thing in excel?

Related to this, would be: Union, and Intersect.


Thanks